Let S be the following schedule of operations of three transactions \(T_1, \…

GATE · 2021 · CS · Set 2 · Computer Science & IT

Let S be the following schedule of operations of three transactions T1, T2T_1, \ T_2 and T3T_3 in a relational database system:

R2(Y),R1(X),R3(Z),R1(Y)W1(X),R2(Z),W2(Y),R3(X),W3(Z)R_2(Y), R_1(X), R_3(Z), R_1(Y)W_1(X), R_2(Z), W_2(Y), R_3(X), W_3(Z)

Consider the statements PP and QQ below:

PP: SS is conflict-serializable.

QQ: If  T3T_3 commits before T1T_1 finishes, then SS  is recoverable.

Which one of the following choices is correct?

  1. A.

    Both PP and QQ are true

  2. B.

    PP is true and QQ  is false

  3. C.

    PP is false and QQ is true

  4. D.

    Both PP and QQ are false

Attempted by 237 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…