What are the properties of the transaction?

Category: SQLWhat are the properties of the transaction?
Editor">Editor Staff asked 2 years ago

 What are the properties of the transaction?

1 Answers
Editor">Editor Staff answered 2 years ago

 Properties of the transaction are known as ACID properties. These are:

  • Atomicity: Ensures the completeness of all transactions performed. Checks whether every transaction is completed successfully or not. If not, then the transaction is aborted at the failure point and the previous transaction is rolled back to its initial state as changes are undone.
  • Consistency: Ensures that all changes made through successful transactions are reflected properly on the database.
  • Isolation: Ensures that all transactions are performed independently and changes made by one transaction are not reflected on others.
  • Durability: Ensures that the changes made in the database with committed transactions persist as it is even after a system failure.