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 isolation level that locks all rows scanned during query execution. This ensures that if the same query is run again, it returns the exact same result set without phantom reads.

Keep practicing — related questions