Database Management Ultimate Quiz!

49 Questions | Total Attempts: 118

SettingsSettingsSettings
Please wait...
Database Management Ultimate Quiz!

Do you know what is database management? Database management allows the user to organize, store and retrieve information from a computer. It can also describe the data storage, operations, and security practices of a database administrator. This quiz will require you to know things like how entity subtypes and supertypes are organized in a specialization hierarchy and important inheritance characteristics. This quiz will teach you about database management and what it entails.


Questions and Answers
  • 1. 
    Entity supertypes and subtypes are organized in a specialization hierarchy.
    • A. 

      True

    • B. 

      False

  • 2. 
    Within a specialization hierarchy, a supertype can exist only within the context of a subtype.
    • A. 

      True

    • B. 

      False

  • 3. 
    The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
    • A. 

      True

    • B. 

      False

  • 4. 
    The property of the subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.
    • A. 

      True

    • B. 

      False

  • 5. 
    One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
    • A. 

      True

    • B. 

      False

  • 6. 
    At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
    • A. 

      True

    • B. 

      False

  • 7. 
    Entity subtypes do not inherit the relationships in which the supertype entity participates.
    • A. 

      True

    • B. 

      False

  • 8. 
    In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.
    • A. 

      True

    • B. 

      False

  • 9. 
    An entity supertype can have disjoint or overlapping entity subtypes.
    • A. 

      True

    • B. 

      False

  • 10. 
    Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
    • A. 

      True

    • B. 

      False

  • 11. 
    Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
    • A. 

      True

    • B. 

      False

  • 12. 
    Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.
    • A. 

      True

    • B. 

      False

  • 13. 
    The completeness constraint can be partial or total.
    • A. 

      True

    • B. 

      False

  • 14. 
    Generalization is based on grouping unique characteristics and relationships of the subtypes.
    • A. 

      True

    • B. 

      False

  • 15. 
    Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
    • A. 

      True

    • B. 

      False

  • 16. 
    An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
    • A. 

      True

    • B. 

      False

  • 17. 
    To model time-variant data, you must create a new entity in an M:N relationship with the original entity.
    • A. 

      True

    • B. 

      False

  • 18. 
    A design trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.
    • A. 

      True

    • B. 

      False

  • 19. 
    Some designs use redundant relationships as a way to simplify the design.
    • A. 

      True

    • B. 

      False

  • 20. 
    The extended entity relationship model (EERM) is sometimes referred to as the ____.
    • A. 

      Entity relationship model

    • B. 

      Enhanced entity relationship model

    • C. 

      Entity clustering relationship model

    • D. 

      Extended entity relationship diagram

  • 21. 
    ____ is a generic entity type that is related to one or more entity subtypes.
    • A. 

      A subtype discriminator

    • B. 

      Inheritance

    • C. 

      A specialization hierarchy

    • D. 

      An entity supertype

  • 22. 
    The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
    • A. 

      Subtype discriminator

    • B. 

      Inheritance

    • C. 

      Specialization hierarchy

    • D. 

      Entity supertype

  • 23. 
    The relationships depicted within the ____ are sometimes described in terms of "is-a" relationships.
    • A. 

      Subtype discriminator

    • B. 

      Inheritance

    • C. 

      Specialization hierarchy

    • D. 

      Entity supertype

  • 24. 
    Every subtype can have ____ supertype(s) to which it is directly related.
    • A. 

      Zero

    • B. 

      Only one

    • C. 

      One or many

    • D. 

      Many

  • 25. 
    A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.
    • A. 

      Zero

    • B. 

      Only one

    • C. 

      One or many

    • D. 

      Many

Related Topics
Back to Top Back to top