Home › GATE CSE › computerscience › Database Management Systems › If T1 writes A, T2 reads that new A before T1 co…
If T1 writes A, T2 reads that new A before T1 commits, and T1 then aborts, T2 has experienced
Aa phantom read anomaly
Ba dirty read of uncommitted data
Can unrepeatable read anomaly
Da lost update problem
Answer & Solution
Correct answer: B. a dirty read of uncommitted data
Reading data written by an uncommitted transaction (which then rolls back) is the textbook dirty read. The value T2 saw was never officially in the database. Phantom involves new rows appearing; unrepeatable read involves the same row changing across two reads in the same transaction; lost update involves concurrent writes overwriting each other.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment