Problem Statement
Match the phenomenon to its description: dirty read, non-repeatable read, phantom read.
Explanation
A dirty read returns data that may later roll back. A non-repeatable read happens when a row read twice returns different values after another commit.
A phantom read adds or removes qualifying rows between two scans of the same predicate, usually on ranges.
Code Solution
SolutionRead Only
SELECT * FROM orders WHERE status='NEW'; -- second read returns different result set
Practice Sets
This question appears in the following practice sets:
