What are the ACID properties in databases? Explain each property and why they matter for data integrity.

Sample answer preview

ACID properties are a set of principles that guarantee reliable processing of database transactions. They ensure data remains accurate and consistent even when failures occur. Atomicity means a transaction is all-or-nothing.