How does normalization help in reducing redundancy in a database?
- Enhances query performance
- Improves data security
- Increases data storage requirements
- Reduces data duplication
Normalization helps in reducing redundancy by organizing data into multiple related tables, thereby minimizing duplicate data entries. This leads to efficient storage utilization and improves data consistency and integrity.
Loading...
Related Quiz
- Which normal form allows multivalued attributes?
- Scenario: During peak hours, several users report slow query performance. How can the DB2 administrator identify the cause and resolve the issue promptly?
- What is the difference between a sensitive and insensitive cursor in DB2?
- Scenario: A company is merging two separate databases into a single DB2 instance. How would you approach the normalization and denormalization process to integrate the data effectively while maintaining consistency and efficiency?
- Scenario: A DBA needs to find the average salary of all employees in a department. Which aggregation function should they use in DB2, and why?