GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Concept 8 Practice Quiz

Adam Peterson 8 Fragen

Quiz starten

Fragen in diesem 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. ARichtig
    2. BFalsch
  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

Informationen

Beschreibung
CPSI 1203 Quiz am Concept 8 Practice Quiz, erstellt von Adam Peterson am 12/03/2018.
Sprache
English
Aufrufe
70
Schlagwörter
cpsi 1203
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck