Which of the following is the default transaction isolation level for SQL Server?
A)Pessimistic
B)Read Committed
C)Serializable
D)Read Uncommitted
E)Repeatable Read

Question

Quizplus · Accepted Answer

The default transaction isolation level for SQL Server is Read Committed. This level ensures that all data read by a transaction has been committed by other transactions and prevents dirty reads. It also guarantees a stable dataset for the duration of the transaction, but does not prevent non-repeatable or phantom reads.

Which of the Following Is the Default Transaction Isolation Level