Home › GATE CSE › computerscience › Database Management Systems › A complete log record for a write operation incl…
A complete log record for a write operation includes
Athe transaction's SQL string only
Btxn id, item id, old value, new value
Conly the new value of the item
Dthe lock mode the transaction acquired
Answer & Solution
Correct answer: B. txn id, item id, old value, new value
Standard log records carry the txn id (to know who), item id (to know what), old value (so undo can restore it) and new value (so redo can re-apply it). The SQL string alone could not be reverse-applied on a crash; only the new value cannot undo; lock mode is concurrency control, not recovery.
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 logPer WAL semantics, a transaction is officially committed at the momentThe write-ahead rule states that