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.