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 is the strictest standard isolation level that prevents phantom reads by locking all rows scanned during query execution. Unlike Read Stability (which locks only rows actually returned) or Cursor Stability (which locks only the current row), Repeatable Read locks the entire row set used to build the result. This ensures that if the same query is re-executed within the transaction, it returns identical results because no other transaction can modify, insert, or delete rows that would affect that result set.

Keep practicing — related questions