Test
Concept 7 Practice Quiz
Este test tiene tipos de pregunta que se abren en el reproductor de siempre.
Preguntas del test (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.
- AVerdadero
- BFalso
Información
- Descripción
- CPSI 1203 Test sobre Concept 7 Practice Quiz, creado por Adam Peterson el 12/03/2018.
- Autor
- Adam Peterson
- Idioma
- English
- Visitas
- 80
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test