|
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.
|