DSSSB TGT CS Mock 03 – Question 178

Which of the following database isolation levels completely prevents Dirty Reads, Non-Repeatable Reads, and Phantom Reads?

• Serializable
• Repeatable Read
• Read Committed
• Read Uncommitted

Under the ANSI SQL standard, ‘Serializable’ is the highest isolation level. It enforces strict range locks or multi-version serializability, eliminating Dirty Reads, Non-Repeatable Reads, and Phantom Reads.