GATE CS 2025 (Forenoon) — Question 15

Database Management Systems (DBMS)Transactions, Concurrency Control, Conflict SerializabilityMCQ1 mark · −1/3 if wrongMedium

A schedule of three database transactions \( T_1 \), \( T_2 \), and \( T_3 \) is shown. \( R_i(A) \) and \( W_i(A) \) denote read and write of data item \( A \) by transaction \( T_i \), \( i = 1, 2, 3 \). The transaction \( T_1 \) aborts at the end. Which other transaction(s) will be required to be rolled back? \( R_1(X) \; W_1(Y) \; R_2(X) \; R_2(Y) \; R_3(Y) \; ABORT(T_1) \)
  1. A
    Only \( T_2 \)
  2. B
    Only \( T_3 \)
  3. C
    Both \( T_2 \) and \( T_3 \)
  4. D
    Neither \( T_2 \) nor \( T_3 \)
Practise the full 2025-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAPractise this subject in the exam simulatorTimed, GATE-style tests with analytics that find your weak topics.
Practise more on Transactions, Concurrency Control, Conflict SerializabilityTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group