Mark As Completed Discussion

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.