What are dirty read, non-repeatable read, phantom read, and lost update?

Answer preview

These are the four classic concurrency anomalies the SQL standard defines isolation levels around. Each one is a specific way that interleaving two transactions can produce a result no serial execution could ever produce.…