Transaction Isolation

Read Uncommitted

Dirty reads, non-repeatable reads and phantom reads can occur.

Read Committed

Dirty reads are prevented; non-repeatable reads and phantom reads can occur.

Repeatable Read

Dirty reads and non-repeatable reads are prevented; phantom reads can occur.

Serializable

Dirty reads, non-repeatable reads and phantom reads are prevented.