Home/Database/Database Design Using Normalization

Database Design Using Normalization MCQs

40 questionsDatabasePage 1 of 5

Practice free Database Design Using Normalization multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 40 questions — no login required.

Question 1medium

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

⚑ Report ✎ Feedback

Question 2easy

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

⚑ Report ✎ Feedback

Question 3easy

Multivalued dependencies should ________ be eliminated.

⚑ Report ✎ Feedback

Question 4hard

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:

⚑ Report ✎ Feedback

Question 5medium

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

⚑ Report ✎ Feedback

Question 6hard

When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

⚑ Report ✎ Feedback

Question 7medium

Creating a read-only database is a task that is ________ assigned to beginning database professionals.

⚑ Report ✎ Feedback

Question 8hard

Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?

⚑ Report ✎ Feedback

Question 9medium

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.

⚑ Report ✎ Feedback