Multiple ChoiceHard 45s
Lost update race
Two requests read a counter value 10, both increment to 11, and both write 11. What anomaly is this?
Options
- 1Phantom read: a transaction sees new rows another committed transaction inserted
- 2Dirty read: a transaction reads uncommitted data written by another in-flight txn
- 3Lost update: a read-modify-write race where one increment is overwritten
- 4Write skew: two transactions each read a snapshot and write disjoint rows concurrently
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.