The drawback of denormalization is that it ____.
A) increases the number of join operations
B) introduces data redundancy
C) limits the number of indexes in use
D) increases the number of repeating groups
E) impedes the relational query optimizer's performance
Correct Answer:
Verified
Q39: In terms of performance, there is no
Q40: Application data requirements that enter into the
Q41: Consider Table A on the "one side"
Q42: One of the reasons for having secondary
Q43: Consider Table A on the "one side"
Q45: The storing derived data physical database design
Q46: Horizontal partitioning _.
A) means dividing the rows
Q47: The common advantage of separating portions of
Q48: Denormalization can improve the _.
A) performance of
Q49: If the primary key of a table
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents