Consider the following read-write schedule 𝑆 over three transactions 𝑇1,…

PYQ GATE 2024

Consider the following read-write schedule 𝑆 over three transactions 𝑇1, 𝑇2, and 𝑇3, where the subscripts in the schedule indicate transaction IDs:

Β  Β  Β   𝑆: π‘Ÿ1(𝑧); 𝑀1(𝑧); π‘Ÿ2(π‘₯); π‘Ÿ3(𝑦); 𝑀3(𝑦); π‘Ÿ2(𝑦); 𝑀2(π‘₯); 𝑀2(𝑦);

Which of the following transaction schedules is/are conflict equivalent to 𝑆 ?

  1. A.

    T1T2T3T_1 T_2 T_3

  2. B.

    T1T3T2T_1 T_3 T_2

  3. C.

    T3T2T1T_3 T_2 T_1

  4. D.

    T3T1T2T_3 T_1 T_2

Attempted by 339 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…