Data Models into Database Designs – General Questions

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

A. Association relationships only
B. Multivalued attributes only
C. Archetype/instance relationships only
D. All of the above use ID dependent entities

Correct Answer:  D. All of the above use ID dependent entities

7. A foreign key is:

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.

Correct Answer:  A. a column containing the primary key of another table

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

A. A foreign key
B. An alternate key
C. A primary key
D. A surrogate key.

Correct Answer:  C. A primary key

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

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.

Correct Answer:  A. either table without specifying parent and child tables.

10. 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?

A. Null status
B. Data type
C. Default value
D. Data constraints

Correct Answer:  C. Default value

Leave A Comment?

six + four =