Home › GATE CSE › computerscience › Database Management Systems › Strict Two-Phase Locking differs from standard 2…
Strict Two-Phase Locking differs from standard 2PL by requiring
Aall locks be acquired before the transaction starts execution
Ball EXCLUSIVE locks be held until commit or abort
Cthe database to use timestamp ordering, not locks
Devery lock release to be matched by an acquire
Answer & Solution
Correct answer: B. all EXCLUSIVE locks be held until commit or abort
Strict 2PL adds the rule: keep X-locks until end-of-transaction. This stops other transactions from reading uncommitted writes, so when one aborts no chain of dependent aborts follows (no cascade). Standard 2PL allows early X-lock release. Pre-acquiring all locks is conservative 2PL, not strict.
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