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

PYQ UGC NET 2016

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 of the following statement is true?

  1. A.

    Both 𝑆1𝑆_1 and 𝑆2𝑆_2 are conflict serializable.

  2. B.

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

  3. C.

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

  4. D.

    Both 𝑆1𝑆_1 and 𝑆2𝑆_2 are not conflict serializable

Attempted by 241 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…