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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    seven + 3 =