Explain the four SQL isolation levels and which anomalies each one prevents.

Answer preview

The SQL standard defines four isolation levels — READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ and SERIALIZABLE — ordered by how many concurrency anomalies they forbid. Higher isolation means more correctness and less concurrency.…