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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Surrogate keys have much meaning for users.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum