Consider the transactions T1, T2, T3 and the schedules S1 and S2 given below.

T1 : r1(x); r1(z); w1(z)

T2 : r2(y); r2(z); w2(z)

T3 : r3(y); r3(x); w3(y)

S1 : r1(x); r3(y); r3(x); r2(y); r2(z); w3(y); w3(z); r1(z); w1(x); w1(z)

S2 : r1(x); r3(y); r2(y); r3(x); r1(Z); r2(z); w3(y); w1(x); w2(z); w1(z)

Which one of the following statements about the schedules is TRUE ?

1
Only S1 is conflict-serializable
2
Only S2 is conflict-serializable
3
Both S1 and S2 are conflict-serializable
4
Neither S1 nor S2 is conflict-serializable

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation