General Questions

Question 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
Answer : Option D

Question 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.
Answer : Option A

Question 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.
Answer : Option C

Question 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.
Answer : Option A

Question 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
Answer : Option C