Question · SQL and MySQL course · Module 9: Indexes and normalization

The cost of redundancy

Why is storing the same information (e.g. a category name) in many rows risky?

Answer options

  • The database will refuse to store such data
  • When the name changes you must fix many rows at once - it is easy to end up with inconsistent data
  • SELECT queries will stop working
  • Indexes disappear automatically

You can check the correct answer by solving this task in the CodeWorlds game.