Consider the transactions T1, T2, T3 ​and the schedules S1 ​and S2 ​given…

PYQ UGC NET 2024

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. A.

    Only S 1 ​ is conflict-serializable

  2. B.

    Only S 2 ​ is conflict-serializable

  3. C.

    Both S 1 ​ and S 2 ​ are conflict-serializable

  4. D.

    Neither S 1 ​ nor S 2 ​ is conflict-serializable

Attempted by 199 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…