Home › GATE CSE › computerscience › Database Management Systems › From strictest to weakest, the correct hierarchy…
From strictest to weakest, the correct hierarchy of schedules is
Arecoverable > strict > cascadeless
Bcascadeless > recoverable > strict
Cstrict > cascadeless > recoverable
Dthey are independent properties, no hierarchy exists
Answer & Solution
Correct answer: C. strict > cascadeless > recoverable
Every strict schedule is cascadeless (no read of uncommitted data follows from no read OR write of uncommitted data). Every cascadeless schedule is recoverable. So strict implies cascadeless implies recoverable. The reverse implications do not hold; recoverable is the weakest of the three, strict the strongest.
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