What is the difference between a SAVEPOINT and a full transaction ROLLBACK?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the difference between a SAVEPOINT and a full transaction ROLLBACK?

Key points

  • SAVEPOINT marks a specific point in a transaction
  • ROLLBACK TO SAVEPOINT undoes work up to that point
  • Full ROLLBACK undoes the entire transaction

Ready to go further?

Start full exam Practice more questions

Related questions