Multiple choice technology databases

Which of the following isolation levels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Repeatable Read isolation level locks all rows that are scanned to build the result set, preventing phantom reads and ensuring that if the same query is executed again within the transaction, the same rows will be returned. Read Stability only locks individual rows as they are read, Cursor Stability locks only the current row position, and Uncommitted Read imposes minimal locking.

Keep practicing — related questions