1D0-541 practice question 16 of 25

Which term describes the rejoining of relations that have been decomposed?

Full set: 128 questions
Answer options
A: Normalization
B: Denormalization Correct answer
C: Referential integrity
D: Domain constraints
Correct Answer:
B. Denormalization
Explanation

Denormalization is a database optimization strategy where redundancy is intentionally introduced to improve query performance. It involves reversing the process of normalization by combining or "rejoining" relations (tables) that were previously decomposed. This reduces the number of complex joins required to retrieve data for frequent queries, leading to faster read operations. The trade-off is increased storage requirements and more complex data modification logic to avoid anomalies.

Why Incorrect

A. Normalization: This is the process of decomposing relations to reduce data redundancy and improve data integrity, which is the opposite of rejoining them.
C. Referential integrity: This is a system of rules that a database management system uses to ensure that relationships between records in related tables are valid.
D. Domain constraints: These are rules that define the valid set of values for a particular attribute (column), ensuring data validity within a single relation.

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 16, "Practical Database Design and Tuning," Section 16.2.2 discusses denormalization as a technique for improving performance by reintroducing redundancy, often by combining tables that were separated during normalization.

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. Chapter 18, "Physical Database Design and Tuning," Section 18.7.2, "Tuning the Schema," describes denormalization as a common tuning technique that involves collapsing tables together from a normalized schema to avoid the overhead of joins.

3. Stanford University. (n.d.). CS145: Introduction to Databases - Lecture Notes on Physical DB Design & Tuning. Stanford University Computer Science Department. Course materials typically explain denormalization as the process of taking a normalized schema and making it non-normalized by combining relations that are frequently joined to speed up queries.

Scroll to Top