in DBMS by

A transaction can be defined as the sequence task that is performed on databases in a logical manner to gain certain results. Operations like Creating, updating, deleting records performed in the database come from transactions.

In simple words, we can say that a transaction means a group of SQL queries executed on database records.

There are 4 transaction controls such as

  • COMMIT: It is used to save all changes made through the transaction.
  • ROLLBACK: It is used to roll back the transaction. All changes made by the transaction are reverted back and the database remains as before.
  • SET TRANSACTION: Set the name of the transaction.
  • SAVEPOINT: It is used to set the point where the transaction is to be rolled back.

Related questions

0 votes
0 votes
asked Feb 28, 2020 in DBMS by rahuljain1
0 votes
asked Dec 13, 2020 in Sql by SakshiSharma
0 votes
asked Mar 31, 2020 in DBMS by amita rallin
0 votes
0 votes
asked Mar 15 in Azure SQL by sharadyadav1986
...