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 locks all rows scanned to build the result set, preventing other transactions from updating or deleting them. Uncommitted Read takes no locks, Cursor Stability locks only the current row, and Read Stability locks only rows that are actually returned (not all scanned rows).

Keep practicing — related questions