FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Database Design Using Normalization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

To check for null values in a column in a table,use the SQL phrase ________.

A) IS
B) IS NOT
C) IS NULL
D) COUNT(IS NOT)
E) COUNT(IS NULL)

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

The problem of misspelled data entries is really the same as ________.

A defining requirement for BCNF is that every determinant must be a candidate key.

The advantages of normalization include ________.

The presence of one or more foreign keys in a relation prevents ________.

You are creating a PRODUCT table using existing data from multiple sources.Examining the data,you find that you have "large red hat","large hat,red","red hat large" and "hat,large,red." This is an example of ________.

A null value in a column may indicate that there is an appropriate value for that attribute,but it is unknown.

What are null values,and why are they a problem?

When examining data values as a part of assessing table structure,you should try to determine multivalued dependencies.

When you are given a set of tables and asked to create a database to store their data,the first step is to ________.

If you have a table with a set of columns named "Child01","Child02" and "Child03",the table has the multivalued,multicolumn problem.

The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.

SQL statements that can be used to create referential integrity statements for normalized tables are created during the normalization process.

When examining data values as a part of assessing table structure,you should try to determine the table's primary key.

The second step in assessing table structure is to examine data values and determine dependencies and keys.

The standard sales order/line item pattern is a classic example of unneeded normalization.

Relations are sometimes left unnormalized to improve performance.

Reviewing the work done on a table that was created using existing data from multiple sources,you find that a column name Remarks has been included,and it is populated with inconsistent and verbose verbal data.This is an example of ________.

The SQL function COUNT ________.