The GATE Grind

GATE 2016 CS (CS2) – Question 32

Databases · Transactions and Concurrency Control · 1 mark · Multiple choice

For a serializable schedule, precedence-graph vertices represent transactions and directed edges represent conflicts. Which vertex ordering yields an equivalent serial schedule?

  1. Topological order
  2. Depth-first order
  3. Breadth-first order
  4. Ascending transaction indices

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (A) Topological order

Explanation

A conflict edge Tᵢ→Tⱼ requires transaction i before transaction j. A topological ordering respects every edge of the acyclic precedence graph and gives the conflict-equivalent serial order. DFS/BFS visitation and numeric labels need not respect those edges. Thus A; this graph criterion concerns conflict serializability.

More Transactions and Concurrency Control questions

All Transactions and Concurrency Control questions →