Multiple choice technology mainframe

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 locks all rows scanned during a transaction. This prevents non-repeatable reads and phantom reads by maintaining locks on the entire result set for the transaction duration.

Keep practicing — related questions