Start learning →

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.
Practise this question with Quill — GATE CSE →

Keep practising Database Management Systems

Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.

Start a Database Management Systems lesson →
Related questions