Teaching Haryana (HPSC) Assistant Professor Mock Test 2025 DBMS Transaction Serializability of Schedules
Let ri(z) and wi(z) denote read and write operations respectively on a data item z by a transaction Ti. Consider the following two schedules.
S1 : r1(x) r1(y) r2(x) r2(y) w2(y) w1(x)
S2 : r1(x) r2(x) r2(y) w2(y) r1(y) w1(x)
Which one of the following options is correct?
1
S1 is conflict serializable, and S2 is not conflict serializable.
2
S1 is not conflict serializable, and S2 is conflict serializable.
3
Both S1 and S2 are conflict serializable.
4
Neither S1 nor S2 is conflict serializable.
5
Question Not Attempted