Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

A table that satisfies 2NF:
A)Always satisfies 1NF
B)May violate 1NF
C)Always satisfies 3NF
D)None of the above
2

A table that satisfies BCNF:
A)Always satisfies 3NF
B)May violate 3NF
C)May satisfy 3NF
D)None of the above
3

For a violation of 2NF to occur in a table in 1NF, the following condition(s) must exist:
A)There must be some specific nontrivial multivalued dependencies
B)There must be transitive dependencies
C)Part of a key determines a nonkey attribute
D)All of the above
4

In a table in 1NF in which the only candidate key is a single attribute:
A)2NF may not be violated
B)3NF may not be violated
C)BCNF may not be violated
D)4NF may not be violated
5

A table in 1NF in which the unique candidate key consists of all the attributes of the table:
A)May violate 3NF
B)May violate 4NF
C)May violate BCNF
D)None of the above
6

A table in 1NF in which the unique candidate key consists of two of its three attributes:
A)Always violates 2NF
B)Never violates 2NF
C)May violate 2NF
D)None of the above
7

If a three-way relationship represented by a table that should actually be represented by two binary relationships, the table violates the following NF (choose the lowest one that applies):
A)2NF
B)BCNF
C)4NF
D)5NF
8

If a three-way relationship represented by a table that should actually be represented by three binary relationships, the table violates the following NF (choose the lowest one that applies):
A)2NF
B)BCNF
C)4NF
D)5NF
9

A violation of BCNF is typical of the following condition(s) on a table:
A)The table has a unique candidate key consisting of one attribute
B)The table has two candidate keys each consisting of one attribute
C)The table has two non-overlapping candidate keys
D)The table has two candidate keys that share a common attribute
10

A table MOVIES in an object-oriented database consists of the attributes title (the primary key), year-produced, and actor-name; actor-name is a repeating group; different movies may have different numbers of actors. The table MOVIES violates the following normal form (choose the lowest one):
A)1NF
B)2NF
C)3NF
D)4NF





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 > Multiple Choice Quiz