General Questions

Question 1 :

Needing to using more complicated SQL in database applications is a(n) ________ of normalization.


A). advantage
B). disadvantage
C). either an advantage or disadvantage
D). neither an advantage nor disadvantage
Answer : Option B

Question 2 :

Eliminating modification anomalies is a(n) ________ of normalization.


A). advantage
B). disadvantage
C). either an advantage or disadvantage
D). neither an advantage nor disadvantage
Answer : Option A

Question 3 :

Multivalued dependencies should ________ be eliminated.


A). always
B). commonly
C). seldom
D). never
Answer : Option A

Question 4 :

When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:


A). first step.
B). second step.
C). third step.
D). fourth step.
Answer : Option C

Question 5 :

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?


A). The multivalue, multicolumn problem
B). The inconsistent values problem
C). The missing values problem
D). The general-purpose remarks column problem
Answer : Option B