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

Question

Quizplus · Accepted Answer

The default transaction isolation level for SQL Server is Read Committed. Maintaining the balance between ACID properties (Atomicity, Consistency, Isolation, and Durability) while providing efficient data access is the main goal. Read Committed ensures that a transaction only sees data that has been committed, thus providing a reasonable balance between isolation and performance.

Which of the Following Is the Default Transaction Isolation Level