Dirty Read

  • Occurs when a transaction sees data that wasn’t committed
  • May occur if a transaction gets rolled back at some point

Non-Repeatable Read

  • When a transaction run multiple times produces different results

Phantom Read

  • When a transaction re-runs a query within a search criteria altering the results (adding or deleting rows) causing the next result to be altered