Q15: What are ACID properties?

Difficulty:MediumTopic:Databases

Atomicity means a transaction commits all its operations or none. Consistency means a transaction preserves defined invariants. Isolation controls how concurrent transactions interact. Durability means committed changes survive failures according to the database's guarantees. ACID is not a substitute for application-level validation, and isolation levels differ in the anomalies they prevent.

Key Takeaways
  • ACID describes transaction guarantees.
  • Know the database's actual isolation level and durability configuration.