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

CSE :: Database System 2 - CS

  1. A foreign key is used to implement relationships between tables.

  2. A.

     True

    B.

     False


  3. The terms alternate key and candidate key mean the same thing.

  4. A.

     True

    B.

     False


  5. In 1:N relationships, which entity becomes the parent entity is arbitrary.

  6. A.

     True

    B.

     False


  7. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

  8. A.

     True

    B.

     False


  9. In a 1:1 relationship, the primary key placement is arbitrary.

  10. A.

     True

    B.

     False


  11. When the parent entity is required, a new child row can always be inserted.

  12. A.

     True

    B.

     False


  13. All primary keys are required.

  14. A.

     True

    B.

     False


  15. Intersection tables are ID-dependent on both their parent tables.

  16. A.

     True

    B.

     False


  17. For every relationship, there are six possible sets of minimum cardinalities.

  18. A.

     True

    B.

     False


  19. An intersection table is required to represent M:N relationships.

  20. A.

     True

    B.

     False