Site MapHelpFeedbackTrue or False Quiz
True or False Quiz
(See related pages)



1

To avoid modification anomalies in a database, it is better to modify the table design than to work around them by writing code or using dummy values.
A)True
B)False
2

3NF/BCNF is the most important normal form in practice because normal forms higher than this involve other kinds of dependencies that are less common and more difficult to understand.
A)True
B)False
3

Using Boyce-Codd normal form (BCNF) allows you to perform the normalization process in one step, as opposed to using 2NF and 3NF which requires two normalization steps.
A)True
B)False
4

Due to the extra joins involved, splitting a table because it has multiple candidate keys can degrade query performance.
A)True
B)False
5

Once all of the functional dependencies have been analyzed and a table is in BCNF, it is safe to assume that the table does not contain any redundancies that would cause modification anomalies.
A)True
B)False
6

In the MVD expressed as A → → B | C, B and C are not independent given the relationships between A and B and A and C.
A)True
B)False
7

Every MDV is an FD but not every FD is an MVD.
A)True
B)False
8

The "ultimate normal form" is considered to be 5NF.
A)True
B)False
9

One of the disadvantages of using normalization as a refinement tool instead of an initial design tool is that M-N relationships can often be overlooked with this approach.
A)True
B)False
10

One advantage of normalization is that data modification operations usually execute faster.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 7 > True or False Quiz