$5\mathrm{.}5\mathrm{.}1$: Transactions with SQL$.$

Jump to level $1$

session begins

SET GLOBAL TRANSACTION

ISOLATION LEVEL READ COMMITTED;

session ends

session begins

SET TRANSACTION

ISOLATION LEVEL READ UNCOMMITTED;

transaction $1$

transaction $2$

SET SESSION TRANSACTION

ISOLATION LEVEL SERIALIZABLE;

transaction $3$

transaction $4$

SET TRANSACTION

ISOLATION LEVEL REPEATABLE READ;

transaction $5$

session ends

Select each transaction's isolation level.

transaction $1$

Pick

transaction $2$ Pick

transaction $3$ Pick

transaction $4$

Pick