Consider following schedules involving two transactions: \(S_{1}: \:…

PYQ UGC NET 2018

Consider following schedules involving two transactions:

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)S_{1}: \: r_{1}(X);r_{1}(Y);r_{2}(X);r_{2}(Y);w_{2}(Y);w_{1}(X) \\ S_{2}: \: r_{1}(X);r_{2}(X);r_{2}(Y);w_{2}(Y);r_{1}(Y);w_{1}(X)

Which one of the following statements is correct with respect to above ?

  1. A.

    Both 𝑆1 and 𝑆2 are conflict serializable.

  2. B.

    𝑆1 is conflict serializable and 𝑆2 is not conflict serializable

  3. C.

    𝑆1 is not conflict serializable and 𝑆2 is conflict serializable

  4. D.

    Both 𝑆1  and 𝑆2 are not conflict serializable

Attempted by 317 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…