Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Select an option to see the answer and solution.
Database · all questionsDatabase Design Using Normalization
Database Design Using Normalization
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
Eliminating modification anomalies is a(n) ________ of normalization.
Select an option to see the answer and solution.
Multivalued dependencies should ________ be eliminated.
Select an option to see the answer and solution.
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:
Select an option to see the answer and solution.
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Select an option to see the answer and solution.
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Select an option to see the answer and solution.
Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Select an option to see the answer and solution.
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Select an option to see the answer and solution.
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Select an option to see the answer and solution.
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Select an option to see the answer and solution.
Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Select an option to see the answer and solution.
When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
Select an option to see the answer and solution.
Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
Select an option to see the answer and solution.
When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
Select an option to see the answer and solution.
If a table has been normalized so that all determinants are candidate keys, then that table is in:
Select an option to see the answer and solution.
Read-only databases are ________ updated.
Select an option to see the answer and solution.
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Select an option to see the answer and solution.
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Select an option to see the answer and solution.
Normalization ________ data duplication.
Select an option to see the answer and solution.
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Select an option to see the answer and solution.