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 during query execution, preventing phantom reads and non-repeatable reads. UR takes no locks, CS locks only current row, and RS locks only qualifying rows. This is the strongest isolation level before Serializable.

Keep practicing — related questions