Home › GATE CSE › computerscience › Database Management Systems › A schedule S is conflict serializable if and onl…
A schedule S is conflict serializable if and only if its precedence graph is
Acomplete (every pair of nodes connected by an edge)
Bconnected (one connected component)
Cacyclic (no directed cycles)
Da tree (exactly one path between any two nodes)
Answer & Solution
Correct answer: C. acyclic (no directed cycles)
The standard theorem: conflict serializable iff acyclic precedence graph. A cycle would mean two transactions each must precede the other in any equivalent serial order, which is impossible. Acyclic graphs have a topological order that gives a valid serial equivalent. Completeness, connectedness and tree-ness are unrelated properties.
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