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 isolation level locks all rows scanned to build the result set, ensuring the same query can be repeated with identical results. UR doesn't lock, CS locks only the current cursor position, and RS only locks rows that match the query criteria.

Keep practicing — related questions