Database Design Using Normalization MCQs
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 29medium
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
Advertisement
Question 31hard
The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
Question 32hard
The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
Question 33hard
We use the SQL construct COUNT(*) to count the number of rows in a table.
Advertisement
Question 34hard
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.
Question 35hard
Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Question 36hard
One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.