Question · SQL and MySQL course · Module 10: Transactions and advanced SQL
Consistency
What does the Consistency principle in ACID guarantee?
Answer options
- All tables have the same number of rows
- After a transaction the database stays in a correct state, in line with the rules (e.g. foreign keys)
- Data is always sorted in ascending order
- Every query returns its result in the same order
You can check the correct answer by solving this task in the CodeWorlds game.