Dirty Read
- Occurs when a transaction sees data that wasn’t committed
- Could occur when a transaction sees data that was rolled back
Read Committed Isolation ensures transactions only see data that was committed
Non-Repeatable Read
- When transactions read the same data twice but yield different results
- “Repeatable Isolation” reduces non-repeatable reads
Phantom Read
- When a transaction re-runs a query and another transaction alters the rows with that search criteria
- When a row is added or deleted by another transaction between an identical query run