Consider the following schedules involving two transactions. S1: r1(X); r1(Y);…

Consider the following schedules involving two transactions.
S1: r1(X); r1(Y); w1(X); r2(X); r2(Y); w2(Y);
S2: r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X)

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

  1. A.

    Both S1 and S2 are conflict serializable.

  2. B.

    Both S1 and S2 are not conflict serializable.

  3. C.

    S1 is conflict serializable and S2 is not conflict serializable.

  4. D.

    S1 is not conflict serializable and S2 is conflict serializable.

Attempted by 120 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…