Explore Library
Quiz

Isolation Levels and Phantom Reads

Identify which SQL isolation level prevents non-repeatable reads but still permits phantom reads under the standard.

Under the ANSI SQL standard, which isolation level guarantees that a row re-read within the same transaction returns the same values, yet still allows phantom reads (new rows matching a range query appearing on re-execution)?