O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Concept 8 Practice Quiz

Adam Peterson 8 perguntas

Fazer o quiz

Perguntas do quiz (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. AVerdadeiro
    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

Informações

Descrição
CPSI 1203 Quiz sobre Concept 8 Practice Quiz, criado por Adam Peterson em 12-03-2018.
Idioma
English
Visualizações
70
Etiquetas
cpsi 1203
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?