What does "Consistency" mean in ACID?
Consistency means every transaction must move the database from one valid state to another, without breaking the rules, constraints, and relations that are set up.
If something goes wrong during execution, the database rolls back to its previous consistent state.
Example: if a table has a rule that the balance can never be negative, then a transaction that would drive it negative never commits - the database keeps its data integrity.
Short Answer
Interview readyPremium
A concise answer to help you respond confidently on this topic during an interview.