Home › GATE CSE › computerscience › Database Management Systems › The defining benefit of MVCC over plain 2PL is
The defining benefit of MVCC over plain 2PL is
AMVCC requires fewer disk writes per transaction
Breaders never block writers, only writer-writer conflicts wait
CMVCC eliminates the need for any timestamps or version numbers
DMVCC always provides full serializability without extra effort
Answer & Solution
Correct answer: B. readers never block writers, only writer-writer conflicts wait
MVCC's signature property is that read-write conflicts disappear, because readers see an older version. Only writer-writer conflicts produce contention. This is why PostgreSQL and Oracle pick MVCC as the default. MVCC USES timestamps/versions (option C is wrong); plain MVCC is snapshot isolation, NOT serializable (option D is wrong).
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