1
GATE CSE 2026 Set 2
MCQ (Single Correct Answer)
+1
-0

Consider concurrent execution of two transactions $T 1$ and $T 2$ in a DBMS, both of which access a data object $A$. For these two transactions to not conflict on $A$, which one of the following statements must be true?

A

Both $T 1$ and $T 2$ only read $A$

B

$T 1$ reads $A$ and $T 2$ writes $A$

C

$T 1$ writes $A$ and $T 2$ reads $A$

D

Both $T 1$ and $T 2$ write $A$

2
GATE CSE 2025 Set 2
MCQ (More than One Correct Answer)
+1
-0.33

An audit of a banking transactions system has found that on an earlier occasion, two joint holders of account $A$ attempted simultaneous transfers of Rs. 10000 each from account $A$ to account $B$. Both transactions read the same value, Rs. 11000, as the initial balance in $A$ and were allowed to go through. $B$ was credited Rs. 10000 twice. $A$ was debited only once and ended up with a balance of Rs. 1000. Which of the following properties is/are certain to have been violated by the system?

A
Atomicity
B
Consistency
C
Isolation
D
Durability
3
GATE CSE 2025 Set 1
MCQ (Single Correct Answer)
+1
-0.33

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) \operatorname{ABORT}\left(T_1\right)$$

A
Only $T_2$
B
Only $T_3$
C
Both $T_2$ and $T_3$
D
Neither $T_2$ nor $T_3$
4
GATE CSE 2024 Set 2
MCQ (Single Correct Answer)
+1
-0.33

Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes are reflected on disk. This property is called

A

durability

B

atomicity

C

consistency

D

isolation

GATE CSE Subjects

Browse all chapters by subject

Software Engineering
Web Technologies