Explain the ACID properties of database transactions and describe a real-world scenario where violating each property would cause a serious problem.

Sample answer preview

ACID properties are the foundation of reliable database transactions. Every database administrator must understand these properties deeply because they directly affect data integrity, application correctness, and system reliability.