Consider the following four schedules due to three transactions (indicated by…

PYQ GATE 2014

Consider the following four schedules due to three transactions (indicated by the subscript) using readread and writewrite on a data item xx, denoted by r(x)r(x) and w(x)w(x) respectively. Which one of them is conflict serializable?

  1. A.

    r1(x);r2(x);w1(x);r3(x);w2(x)r_1(x); r_2(x); w_1(x); r_3(x); w_2(x)

  2. B.

    r2(x);r1(x);w2(x);r3(x);w1(x)r_2(x);r_1(x);w_2(x);r_3(x);w_1(x)

  3. C.

    r3(x);r2(x);r1(x);w2(x);w1(x)r_3(x);r_2(x);r_1(x);w_2(x);w_1(x)

  4. D.

    r2(x);w2(x);r3(x);r1(x);w1(x)r_2(x);w_2(x);r_3(x);r_1(x);w_1(x)

Attempted by 299 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…