Database Design Using Normalization - Study Mode

Show All Answers

[#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