Multiple choice technology databases

Which isolation level prevents phantom reads

  1. 0

  2. 3

  3. 2

  4. 1
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Isolation level 3 (serializable) prevents phantom reads by locking entire ranges of keys, not just individual rows. This is the highest isolation level in Sybase ASE, ensuring complete transaction isolation by preventing other transactions from inserting rows that would match the query.

Keep practicing — related questions