1. 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.

A. True
B. False


Correct Answer:  B. False

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

A. True
B. False


Correct Answer:  A. True

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

A. True
B. False


Correct Answer:  A. True

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

A. True
B. False


Correct Answer:  B. False

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

A. True
B. False


Correct Answer:  B. False

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

two × two =