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.