Problem Statement
Which mapping is correct for standard SQL isolation levels and phenomena prevented?
Explanation
As isolation increases, more anomalies are blocked. Read Committed avoids dirty reads. Repeatable Read also stabilizes previously read rows. Serializable enforces the same outcome as some serial order of transactions and eliminates phantoms.
Engines vary: some provide Snapshot Isolation variants that behave between Repeatable Read and Serializable for common workloads.
Code Solution
SolutionRead Only
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Practice Sets
This question appears in the following practice sets:
