Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
Repeatable Read isolation level most reduces concurrency by ensuring that if a transaction reads a row, subsequent transactions are prevented from modifying that row until the initial transaction is finished. This level keeps shared locks on all read data until the end of the transaction, which is likely to cause lock escalations, impacting overall system performance.
Correct