Database Ch 6

50 Questions | Total Attempts: 39

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

While working on a computer, a lot of data is transmitted through sending commands and retrieving responses. All this information is stored in data storages called databases. All the IT guys in the world over, this quiz is for you.


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

      True

    • B. 

      False

  • 2. 
    The relationships depicted within the specialization hierarchy are sometimes described in terms of is-a relationships.
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 9. 
    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 subtype.
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 19. 
    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

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

      True

    • B. 

      False

  • 21. 
    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

  • 22. 
    ____ 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

  • 23. 
    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

  • 24. 
    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

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

      Zero

    • B. 

      Only one

    • C. 

      One or many

    • D. 

      Many

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

      Zero

    • B. 

      Only one

    • C. 

      One or many

    • D. 

      Many

  • 27. 
    Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype entity set.
    • A. 

      Entity

    • B. 

      Subtypes

    • C. 

      Unique

    • D. 

      Nonunique

  • 28. 
    In the specialization hierarchy there is a ____ relationship between a subtype and supertype.
    • A. 

      Self-referring

    • B. 

      1:1

    • C. 

      1:M

    • D. 

      M:N

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

      Primary

    • B. 

      Natural

    • C. 

      Foreign

    • D. 

      Surrogate

  • 30. 
    The default comparison condition for the subtype discriminator attribute is the ____ comparison.
    • A. 

      Not equality

    • B. 

      Less than

    • C. 

      Greater than

    • D. 

      Equality

  • 31. 
    A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
    • A. 

      Subtype discriminator

    • B. 

      Inheritance discriminator

    • C. 

      Specialization hierarchy

    • D. 

      Entity supertype

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

      Subtype discriminator

    • B. 

      Inheritance

    • C. 

      Specialization hierarchy

    • D. 

      Entity supertype

  • 33. 
    ____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
    • A. 

      Specialization

    • B. 

      Generalization

    • C. 

      Partial completeness

    • D. 

      Total completeness

  • 34. 
    If one exists, a data modeler uses a ____ as the primary key of the entity being modeled.
    • A. 

      Foreign key

    • B. 

      Combination key

    • C. 

      Surrogate key

    • D. 

      Natural identifier

  • 35. 
    An entity cluster is formed by combining multiple interrelated entities into ____.
    • A. 

      A single abstract entity object

    • B. 

      Multiple abstract entity object

    • C. 

      A single entity object

    • D. 

      Multiple entity objects

  • 36. 
    Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.
    • A. 

      Entity

    • B. 

      Subtypes

    • C. 

      Unique

    • D. 

      Nonunique

  • 37. 
    A ____ key is a real-world, generally accepted identifier used to distinguish that is, uniquely identify-real-world objects.
    • A. 

      Primary

    • B. 

      Natural

    • C. 

      Foreign

    • D. 

      Surrogate

  • 38. 
    The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.
    • A. 

      Primary

    • B. 

      Natural

    • C. 

      Foreign

    • D. 

      Surrogate

  • 39. 
    The primary key's main function is to uniquely identify a(n) ____ within a table.
    • A. 

      Attribute

    • B. 

      Entity instance or row

    • C. 

      Entity subtype

    • D. 

      Natural identifier

  • 40. 
    The “____” characteristic of a primary key states that: The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls.
    • A. 

      Unique values

    • B. 

      Nonintelligent

    • C. 

      Preferably single-attribute

    • D. 

      Security complaint

  • 41. 
    The “____” characteristic of a primary key states that: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK in an EMPLOYEE table is not a good idea.
    • A. 

      Unique values

    • B. 

      Nonintelligent

    • C. 

      Preferably single-attribute

    • D. 

      Security complaint

  • 42. 
    The “____” characteristic of a primary key states that: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.
    • A. 

      Unique values

    • B. 

      Nonintelligent

    • C. 

      Preferably single-attribute

    • D. 

      Security complaint

  • 43. 
    Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.
    • A. 

      0:1

    • B. 

      1:1

    • C. 

      1:M

    • D. 

      M:N

  • 44. 
    Surrogate primary keys are especially helpful when there is no ____ key.
    • A. 

      Primary

    • B. 

      Natural

    • C. 

      Foreign

    • D. 

      Composite

  • 45. 
    ____ keys work with primary keys to properly implement relationships in the relational model.
    • A. 

      Foreign

    • B. 

      Composite

    • C. 

      Natural

    • D. 

      Surrogate

  • 46. 
    The preferred placement for a foreign key when working with a 1:1 relationship is ____.
    • A. 

      Use the same primary key for both entities

    • B. 

      Create a bridge entity

    • C. 

      Place a foreign key in one of the entities

    • D. 

      Place a foreign key in both entities

  • 47. 
    ____ data refer to data whose values change over time and for which you must keep a history of the data changes.
    • A. 

      Time-sensitive

    • B. 

      Time-variant

    • C. 

      Historical

    • D. 

      Change-based

  • 48. 
    A ____ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.
    • A. 

      Surrogate primary keys

    • B. 

      Time-variant data

    • C. 

      Design trap

    • D. 

      Fan trap

  • 49. 
    ____ relationships occur when there are multiple relationship paths between related entities.
    • A. 

      Redundant

    • B. 

      Duplicated

    • C. 

      Time-variant

    • D. 

      Supertype

  • 50. 
    According to the data modeling checklist, ____ should clearly define participation and cardinality rules.
    • A. 

      Entities

    • B. 

      Naming conventions

    • C. 

      Relationships

    • D. 

      Attributes