Which of the following is a potential drawback of denormalization?
- Enhanced query performance
- Improved data integrity
- Increased risk of data inconsistency
- Reduced storage space
One potential drawback of denormalization is the increased risk of data inconsistency. Denormalizing tables may lead to duplicated data across the database, making it more challenging to maintain data consistency. Changes to data in one location may not be reflected in all duplicated instances, resulting in inconsistencies. Thus, careful consideration is needed while denormalizing to balance performance benefits with the risk of data inconsistency.
Loading...
Related Quiz
- Which normal form requires all determinants to be candidate keys?
- Nesting tags in DB2 allows for better organization and ________ of the database structure.
- Scenario: A company is designing an ERD for its HR system. They identify a scenario where an employee may have multiple dependents, but a dependent can only belong to one employee. What type of relationship does this represent in the ERD?
- What are some features of DB2 that enhance performance tuning?
- In DB2, a view allows users to ________ data from one or more tables.