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

CSE :: Database System 2 - CS

  1. The DBMS allows surrogate keys to be changed.

  2. A.

     True

    B.

     False


  3. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

  4. A.

     True

    B.

     False


  5. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

  6. A.

     True

    B.

     False


  7. Surrogate keys have much meaning for users.

  8. A.

     True

    B.

     False


  9. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

  10. A.

     True

    B.

     False


  11. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

  12. A.

     True

    B.

     False


  13. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

  14. A.

     True

    B.

     False


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

  16. A.

     True

    B.

     False


  17. For every relationship, there are six possible referential integrity actions.

  18. A.

     True

    B.

     False


  19. An ideal primary key is short, numeric and seldom changing.

  20. A.

     True

    B.

     False