GATE | IT | 2004 | DBMS | Transactions | Question 77 (original) (raw)

geeksforgeeks

Last Updated :

Discuss

Comments

Consider the following schedule S of transactions T1 and T2:

T1 T2
Read(A)A = A - 10 Read (A)Temp = 0.2*A Write(A) Read(B)
Write(A)Read(B) B = B + 10 Write(B) B = B + TempWrite(B)

S is serializable only as T1, T2

S is serializable only as T2, T1

S is serializable both as T1, T2 and T2, T1

S is serializable either as T1 or as T2

None of these

This question is part of this quiz :

Transactions and concurrency control,

GATE-IT-2004

Tags:

DBMS Quiz

GATE

Share your thoughts in the comments

author

GeeksforGeeks