What is a transaction and what are ACID properties?

Aditya Patel

Total Post:11

Points:55

Posted by  Aditya Patel
 155  View(s)
Ratings:
Rate this:
  1. What is a transaction and what are ACID properties?

    Where a transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, and Durability. These are the properties of a transaction.

    Atomicity: In this property, the server ensures the completeness of all transactions performed. After checks, every transaction is completed successfully if not then transaction is aborted at the failure point and the previous transaction is rolled back to its initial state as changes are undone .

    Consistency: In this property, the server ensures that all changes made through successful transaction are reflected properly on the database.

    Isolation: In this property, The server ensures that all transactions are performed independently and changes made by one transaction are not reflected on other .

    Durability: In this property, The server ensures that the changes made in the database with committed transactions persist as it is even after a system failure.

      Modified On Sep-24-2019 01:59:23 AM

Answer