Database Design Using Normalization Online Test, Database Design MCQ

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

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

Multivalued dependencies should ________ be eliminated.

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:

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

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

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

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

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

Most of the time, modification anomalies are serious enough that tables should be normalized into:

Each answer below shows example data from a table. Which answer is an example of the missing values problem?

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

Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?

When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

If a table has been normalized so that all determinants are candidate keys, then that table is in:

Read-only databases are ________ updated.

Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.

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

Normalization ________ data duplication.

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

When building a database from an existing set of tables, we still need to consider normalization principles.

We have normalized a table into BCNF if all candidate keys are determinants.

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

In all cases, normalization into BCNF is desirable.

Denormalized tables are in BCNF.

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

Proper normalization eliminates duplicated data.