Transaction Control

The commands used to manage transactions are as follows:

• BEGIN TRANSACTION – This command marks the start of each transaction.
• COMMIT – This command saves the changes to the database in a permanent manner.
• ROLLBACK – This command reverses any modifications, returning them to their original condition.
• SAVEPOINT – this command enables us to roll back transactions in parts rather than all at once by establishing points within groups of transactions.
• RELEASE SAVEPOINT – This command is used to delete an existing SAVEPOINT.
• SET TRANSACTION – This command gives us the ability to give a transaction a name and specify whether we want it to be read-only, read/write, or to belong to a certain rollback segment.