Which of the following is the most restrictive transaction isolation level option supported by SQL Server?
A)Repeatable Read
B)Read Committed
C)Serializable
D)Read Uncommitted

Question

Quizplus · Accepted Answer

Serializable is the most restrictive transaction isolation level option. It ensures that concurrent transactions cannot modify or include data that has been modified by another uncommitted transaction. This provides the highest level of data consistency but can also cause the most blocking and deadlocking. Repeatable Read and Read Committed also provide high levels of data consistency but allow for more concurrency. Read Uncommitted provides the lowest level of data consistency but allows for the highest amount of concurrency.

Which of the Following Is the Most Restrictive Transaction Isolation