The presence of one or more foreign keys in a relation prevents ________.
A) the elimination of modification anomalies
B) the elimination of duplicated data
C) more complex SQL for multitable subqueries and joins
D) A and B
E) A,B,and C
Correct Answer:
Verified
Q63: A classic example of unneeded normalization is
Q64: _ is the process of joining two
Q65: When a table is created using existing
Q66: To count the number of rows in
Q67: The advantages of normalization include _.
A)the elimination
Q69: The SQL keyword TOP _.
A)limits the number
Q70: An advantage of denormalization is _.
A)faster updating
B)faster
Q71: Unlike the anomalies from functional dependencies,the anomalies
Q72: You have been given two tables,CUSTOMER and
Q73: The disadvantages of normalization include _.
A)the elimination
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