ACID Properties in DBMS

Q&A: Explain the ACID properties of database transactions (Atomicity, Consistency, Isolation, Durability), with particular focus on consistency and isolation, and describe how transactions maintain these properties in real-world scenarios (e.g. concurrent updates, isolation levels, rollback on failure).