Week 12 (9)

Transaction Isolation Levels (cont)

Meaning of transaction isolation levels:

Isolation      Dirty          Nonrepeatable   Phantom
Level          Read           Read            Read

Read           Possible       Possible        Possible
uncommitted
 
Read           Not possible   Possible        Possible
committed

Repeatable     Not possible   Not possible    Possible
read

Serializable   Not possible   Not possible    Not possible