Consider the following transactions operating on database items X and Y with…
PYQ IBPS SO CRP SPL-XIV (2024)
Consider the following transactions operating on database items X and Y with initial values:
X=200,Y=100
Transaction T1
· Read X
· X := X − 10
· Write X
Transaction T2
· Read Y
· Y := Y + 20
· Write Y
Both transactions execute completely and exactly once in any serial order without rollback or failure. What will be the final values of X and Y?
- A.
X = 190, Y = 120
- B.
X = 210, Y = 120
- C.
X = 190, Y = 100
- D.
X = 200, Y = 100
- E.
X = 210, Y = 80
Attempted by 53 students.
Sign up free to check your answer
Sign up freeLoading lesson…

