Transactions
•COMMIT ensures that only moves to a new
state
if all queries in a transaction succeed.
•ROLLBACK ensures that the
database returns to the state it had before all queries in a transaction
have been applied.
•SAVEPOINT marks a state to which the database can be
rolled back.