Databases · Middle · Question 24 of 75

What is a savepoint?

1A copy of the database at commit time
2An automatic backup taken every hour
✓Correct answer: A marker inside a transaction you can roll back to without aborting the whole transaction

Explanation

SAVEPOINT s; ... ROLLBACK TO s; undoes only the work since the savepoint. ORMs use savepoints for nested transactions.

Further reading

PostgreSQL: Transactions ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.