What is isolation anomaly in SQL transactions?

Isolation anomalies occur when concurrent transactions produce unexpected results.

Isolation anomalies include dirty reads (reading uncommitted data), non-repeatable reads (same query returns different results), and phantom reads (new rows appear between reads). These anomalies depend on isolation levels like READ COMMITTED or SERIALIZABLE.