Transaction sequence: A bank account starts with balance 1500. A SAVEPOINT is…
2025
Transaction sequence: A bank account starts with balance 1500.
A SAVEPOINT is set.
100 is added to the account.
ROLLBACK TO SAVEPOINT is performed.
COMMIT is issued.
What is the final account balance?
- A.
Account increases
- B.
Account decreases
- C.
Account remains same (1500)
- D.
Account becomes 0
- E.
None of the above
Attempted by 56 students.
Show answer & explanation
Correct answer: C
Correct answer: The account remains the same: 1500.
The savepoint is created before adding 100, so the later rollback returns the transaction to the saved point.
After rollback, the addition is undone. The final COMMIT only makes the rolled-back state permanent, so the balance stays 1500.