1.

What is meant by ACID properties in DBMS?

Answer»

ACID stands for Atomicity, Consistency, Isolation, and Durability in a DBMS these are those properties that ensure a SAFE and secure way of sharing data AMONG multiple users.

  • Atomicity: This property reflects the concept of either executing the whole query or executing nothing at all, which implies that if an update occurs in a database then that update should either be reflected in the whole database or should not be reflected at all.
  • Consistency: This property ENSURES that the data remains consistent before and after a transaction in a database.
  • Isolation: This property ensures that each transaction is occurring INDEPENDENTLY of the others. This implies that the state of an ongoing transaction doesn’t AFFECT the state of another ongoing transaction.
  • Durability: This property ensures that the data is not lost in cases of a system failure or restart and is present in the same state as it was before the system failure or restart.


Discussion

No Comment Found