¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

Concept 8 Practice Quiz

Adam Peterson 8 preguntas

Hacer el test

Preguntas del test (8)

  1. 1When 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 _____.
    1. Aone side is mandatory and the other side is optional
    2. Bone side participates in another relationship
    3. Cboth sides are optional
    4. Dboth sides are mandatory
  2. 2The “_____” 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.
    1. Aunique values
    2. Bnonintelligent
    3. Cpreferably single-attribute
    4. Dsecurity-complaint
  3. 3The function of the primary key is to describe an entity.
    1. AVerdadero
    2. BFalso
  4. 4A primary key's main function is to uniquely identify a(n) _____ within a table.
    1. Aattribute
    2. Bentity instance or row
    3. Centity subtype
    4. Dnatural key or identifier
  5. 5According to the “preferably single-attribute” characteristic of a primary key, the primary key:
    1. Amust be able to guarantee unique attribute values.
    2. Bshould have the minimum number of attributes possible.
    3. Cshould have embedded semantic meaning associated with each attribute.
    4. Dmust be composed of attributes that are free from security risks or violations.
  6. 6At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n) _____ relationship.
    1. Aself-referencing
    2. B1:1
    3. C1:M
    4. DM:N
  7. 7_____ keys work with primary keys to properly implement relationships in the relational model.
    1. AForeign
    2. BComposite
    3. CNatural
    4. DSurrogate
  8. 8_____ relationships occur when there are multiple relationship paths between related entities.
    1. ARedundant
    2. BDuplicated
    3. CTime-variant
    4. DSupertype

Información

Descripción
CPSI 1203 Test sobre Concept 8 Practice Quiz, creado por Adam Peterson el 12/03/2018.
Idioma
English
Visitas
70
Etiquetas
cpsi 1203
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?