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

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…