Home / CSE / Database System 2 - CS :: Data Models into Database Designs

CSE :: Database System 2 - CS

  1. The identifier of an entity will become the ________ of the new table.

  2. A.

     foreign key

    B.

     main attribute

    C.

     primary key

    D.

     identity key

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

  4. A.

     A domain constraint

    B.

     A range constraint

    C.

     An intrarelation constraint

    D.

     An interrelation constraint

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

  6. A.

     primary key.

    B.

     foreign key.

    C.

     composite key.

    D.

     surrogate key.

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Which is not true about surrogate keys?

  8. A.

     They are short.

    B.

     They are fixed.

    C.

     They have meaning to the user.

    D.

     They are numeric.

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

  10. A.

     Two

    B.

     Three

    C.

     Four

    D.

     Six

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

  12. A.

     MUST COVER

    B.

     MUST NOT

    C.

     Both of the above

    D.

     None of the above is correct

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Each entity is represented as a(n):

  14. A.

     tuple.

    B.

     table.

    C.

     attribute.

    D.

     file.

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. For every relationship, how many possible sets of minimum cardinalities are there?

  16. A.

     Two

    B.

     Three

    C.

     Four

    D.

     Six

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

  18. A.

     the primary key

    B.

     any alternate key

    C.

     a surrogate key

    D.

     a foreign key

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

  20. A.

     Null status

    B.

     Data type

    C.

     Default value

    D.

     Data constraints

    View Answer

    Workspace

    Discuss Discuss in Forum