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

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 46 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…