Database Design Using Normalization – General Questions

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

Correct Answer:  B. disadvantage

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

Correct Answer:  A. advantage

3. Multivalued dependencies should ________ be eliminated.

A. always
B. commonly
C. seldom
D. never

Correct Answer:  A. always

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

Correct Answer:  C. third step.

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

Correct Answer:  B. The inconsistent values problem

Leave A Comment?

nineteen − 12 =