How can phantom reads be prevented without using SERIALIZABLE isolation level?

hard📝 Application Q9 of 15

SQL - Transactions and Data Integrity

ABy using REPEATABLE READ with predicate locking

BBy using READ UNCOMMITTED isolation level

CBy disabling transactions

DBy setting isolation level to READ COMMITTED

Step-by-Step Solution

Solution:

Step 1: Define phantom reads
Phantom reads occur when new rows appear in repeated queries.
Step 2: Identify isolation preventing phantoms without SERIALIZABLE
REPEATABLE READ with predicate locking can prevent phantoms.
Final Answer:
By using REPEATABLE READ with predicate locking -> Option A
Quick Check:
Predicate locking blocks phantoms [OK]

Quick Trick: Predicate locking prevents phantom reads [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes