Consider a schedule of transactions T1 and T2: Here, RX stands for “Read(X)” and WX stands for “Write(X)”. Which one of the following schedules is conflict equivalent to the above schedule?
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2020 · Q37
Time

Select one answerSingle correct
Solution
Official answer: A)
Transactions and Concurrency ControlTwo schedules are conflict equivalent if they involve the same set of operations and order every pair of conflicting operations in the exact same way.
Let us identify the conflicting pairs between and in the given schedule:
On data item :
occurs before
occurs before
On data item :
occurs before
On data item :
occurs before
Now check the given options:
In Schedule (A):
On : 's and precede 's ( maintained).
On : 's precedes 's ( maintained).
On : 's precedes 's ( maintained).
Since all conflicting operation pairs preserve the exact same relative ordering, schedule (A) is conflict equivalent to the given schedule.
Try the question first, then check your work.
Examiner trap
Identify all pairs of conflicting operations (operations from different transactions accessing the same item where at least one is a write) and ensure their relative order is preserved.
This Transactions and Concurrency Control previous year question is Q37 of the GATE CSE 2020 paper. Find more GATE CSE PYQs on Transactions and Concurrency Control in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related Transactions and Concurrency Control PYQs now with no account.
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
Transactions and Concurrency Control has 25 GATE CSE PYQs across 20 papers from 2012 to 2026. 12 of them are 2-mark MCQs like this one, and it is the only one in GATE CSE 2020.
How GATE tests Transactions and Concurrency ControlIndependent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.