Database Design Using Normalization MCQs
Practice Database Design Using Normalization MCQs for competitive exams.
Database Design Using Normalization MCQs
Practice questions from this topic.
When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
Correct Answer: B
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
Correct Answer: A
Normalization requires programmers to write more complex SQL.
Correct Answer: A
One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
Correct Answer: B
One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
Correct Answer: A
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Correct Answer: B
When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
Correct Answer: B
We use the SQL construct COUNT(*) to count the number of rows in a table.
Correct Answer: A
The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
Correct Answer: A
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
Correct Answer: A
Proper normalization eliminates duplicated data.
Correct Answer: B
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
Correct Answer: A