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?

  1. A.

    X = 190, Y = 120

  2. B.

    X = 210, Y = 120

  3. C.

    X = 190, Y = 100

  4. D.

    X = 200, Y = 100

  5. E.

    X = 210, Y = 80

Attempted by 53 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Mains

Loading lesson…