What is a phantom read, and which isolation level prevents it?

SQL Data Analyst Hard

SQL Data Analyst — Hard

Key points

SERIALIZABLE prevents phantom reads by locking the entire range of rows a query accesses.
REPEATABLE READ prevents non-repeatable reads, not phantom reads.
READ COMMITTED prevents dirty reads, not phantom reads.
SNAPSHOT prevents inconsistent reads, not phantom reads.

Ready to go further?

Start full exam Practice more questions