Quiz
Concept 7 Practice Quiz
This quiz has question types that open in the usual player.
Questions in this quiz (6)
1A _____ is a primary key created by a database designer to simplify the identification of entity instances.
- Acomposite key
- Bcompound key
- Cnatural key
- Dsurrogate key
2A [blank_start]_____[blank_end] [blank_start]_____[blank_end] occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
- Adesign
- Btrap
3A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.
- Azero
- Bonly one
- Cone or many
- Dmany
4When selecting a foreign key placement for a 1:1 relationship, place the PK of the entity on the mandatory side in the entity on the optional side as a FK, and make the FK mandatory when _____.
- Aone side is mandatory and the other side is optional
- Bone side participates in another relationship
- Cboth sides are optional
- Dboth sides are mandatory
5The “_____” characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.
- Aunique values
- Bnonintelligent
- Cpreferably single-attribute
- Dsecurity-complaint
6The function of the primary key is to describe an entity.
- ATrue
- BFalse
Information
- Description
- CPSI 1203 Quiz on Concept 7 Practice Quiz, created by Adam Peterson on 12/03/2018.
- Author
- Adam Peterson
- Language
- English
- Views
- 80
- Tags
- Rating
- No ratings yet Rate this quiz