CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 14

3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that
make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)
referential
restrictive
secondary
redundant
4. (TCO 2) A field that consists of integer values is a _________ type field. (Points : 4)
Date/Time
Yes/No
Memo
Numeric
5. (TCO 3) The PK must uniquely identify each entity instance. A primary key must be
able to guarantee unique values. It cannot contain nulls. This rationale belongs to ____.
(Points : 4)
Unique values
Nonintelligent
Preferably single-attribute
Security complaint
6. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be
in_____________. (Points : 4)
1NF.
2NF.
3NF.
4NF.