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

CSE :: Database System 2 - CS

  1. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

  2. A.

     A domain constraint

    B.

     A range constraint

    C.

     An intrarelation constraint

    D.

     An interrelation constraint

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. In a 1:N relationship, the foreign key is placed in:

  4. A.

     either table without specifying parent and child tables.

    B.

     the parent table.

    C.

     the child table.

    D.

     either the parent table or the child table.

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which of the following column properties specifies whether or not cells in a column must contain a data value?

  6. A.

     Null status

    B.

     Data type

    C.

     Default value

    D.

     Data constraints

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. A primary key should be defined as:

  8. A.

     NULL.

    B.

     NOT NULL.

    C.

     Either of the above can be used.

    D.

     None of the above are correct.

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

  10. A.

     Null status

    B.

     Data type

    C.

     Default value

    D.

     Data constraints

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which of the following situation requires the use of ID-dependent entities?

  12. A.

     Association relationships only

    B.

     Multivalued attributes only

    C.

     Archetype/instance relationships only

    D.

     All of the above use ID dependent entities

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A foreign key is:

  14. A.

     a column containing the primary key of another table.

    B.

     used to define data types.

    C.

     used to define null status.

    D.

     all of the above are above correct.

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which of the following columns is(are) are required in a table?

  16. A.

     A foreign key

    B.

     An alternate key

    C.

     A primary key

    D.

     A surrogate key

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. In a 1:1 relationship, the foreign key is placed in:

  18. A.

     either table without specifying parent and child tables.

    B.

     the parent table.

    C.

     the child table.

    D.

     either the parent table or the child table.

    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 be immediately filled with a monetary value of $10,000?

  20. A.

     Null status

    B.

     Data type

    C.

     Default value

    D.

     Data constraints

    View Answer

    Workspace

    Discuss Discuss in Forum