A schedule of three database transactions \(𝑇_1, 𝑇_2\), and \(𝑇_3\) is…

GATE Β· 2025 Β· CS Β· Set 1 Β· Computer Science & IT

A schedule of three database transactions 𝑇1,𝑇2𝑇_1, 𝑇_2, and 𝑇3𝑇_3 is shown. 𝑅𝑖(𝐴)𝑅_𝑖(𝐴) andΒ π‘Šπ‘–(𝐴)π‘Š_𝑖(𝐴) denote read and write of data item 𝐴𝐴 by transaction 𝑇𝑖,𝑖=1,2,3𝑇_𝑖 , 𝑖 = 1,2,3. The transaction 𝑇1𝑇_1 aborts at the end. Which other transaction(s) will be required to be rolled back?

𝑅1(𝑋)π‘Š1(π‘Œ)𝑅2(𝑋)𝑅2(π‘Œ)𝑅3(π‘Œ)𝐴𝐡𝑂𝑅𝑇(𝑇1)𝑅_1 (𝑋) π‘Š_1 (π‘Œ) 𝑅_2 (𝑋) 𝑅_2 (π‘Œ) 𝑅_3 (π‘Œ) 𝐴𝐡𝑂𝑅𝑇(𝑇_1 )

  1. A.

    Only 𝑇2𝑇_2

  2. B.

    Only 𝑇3𝑇_3

  3. C.

    Both 𝑇2𝑇_2 and 𝑇3𝑇_3

  4. D.

    Neither 𝑇2𝑇_2 nor 𝑇3𝑇_3

Attempted by 419 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…