GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Concept 8 Practice Quiz

Adam Peterson 8 questions

Take the quiz

Questions in this 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. ATrue
    2. BFalse
  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

Information

Description
CPSI 1203 Quiz on Concept 8 Practice Quiz, created by Adam Peterson on 12/03/2018.
Language
English
Views
70
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?