Concept 10 Practice Quiz

Question 1

A table is in BCNF if every determinant in the table is a foreign key.

Answer

true

Question 2

Most designers consider the BCNF as a special case of the _____.

Accepted Answer

3NF

Answer

1NF

Answer

2NF

Answer

4NF

Question 3

Normalization should be part of the design process.

Answer

true

Question 4

A table is in 4NF if it is in 3NF, and _____.

Accepted Answer

it has no multivalued dependencies

Answer

all attributes must be dependent on the primary key and must be dependent on each other

Answer

all attributes are unrelated

Answer

no column contains the same values

Question 5

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

Answer

true

Question 6

Normalization is a process that is used for changing attributes to entities.

Answer

true

Question 7

When designing a database, you should _____.

Accepted Answer

make sure that entities are in normal form before table structures are created

Answer

create table structures then normalize the database

Answer

only normalize the database when performance problems occur

Answer

consider more important issues such as performance before normalizing

Question 8

When a table contains only one candidate key, _____ are considered to be equivalent.

Accepted Answer

the 3NF and the BCNF

Answer

the 1NF and the 2NF

Answer

the 4NF and the 3NF

Answer

the BCNF and the DKNF

Question 9

Normalization produces a lower normal form.

Answer

true

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden