Home › GATE CSE › computerscience › Database Management Systems › In the Wait-Die deadlock-prevention protocol, wh…
In the Wait-Die deadlock-prevention protocol, when T_i requests a lock held by T_j and T_i has a LARGER timestamp (younger), T_i
Adies (aborts and restarts later)
Bwounds T_j (T_j aborts and restarts)
Cwaits for T_j to release the lock
Dis granted the lock immediately
Answer & Solution
Correct answer: A. dies (aborts and restarts later)
Wait-Die rule: if the requester is younger (larger timestamp), it dies. If the requester is older (smaller timestamp), it waits. Wound-Wait flips the action: the older one wounds the younger holder. Either way, the protocol prevents the formation of any deadlock cycle.
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