1D0-541 practice question 16 of 25
Which term describes the rejoining of relations that have been decomposed?
Full set: 128 questionsDenormalization 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.
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.
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.
Keep practicing
Take the free 1D0-541 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1D0-541 practice questions
- Question 3To create a view, what are the minimal privileges that a user must have for the relations…
- Question 5Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Na…
- Question 7Which subset of Structured Query Language (SQL) is used to limit access to a database or …
- Question 10Which statement accurately describes a characteristic of attributes?
- Question 11In a relational database, which term describes a single table consisting of rows and colu…
- Question 12Which of the following occurs in a relation when records are added or removed?
