🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Transactions and ACID: all 10 questions

Quiz: Transactions and ACID · Question 6 of 10

Inside a long transaction you want to undo only the last few statements, not everything. What do you use?

Inside a long transaction you want to undo only the last few statements, not everything. What do you use?

  1. A.COMMIT
  2. B.SAVEPOINT and ROLLBACK TO that savepoint
  3. C.TRUNCATE
  4. D.A new database
Answer & explanation

Correct answer: SAVEPOINT and ROLLBACK TO that savepoint

A savepoint marks a point you can roll back to without cancelling the whole transaction.

Can you get the rest right without peeking?

Take the timed Quiz: Transactions and ACID quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →