General Questions

Question 16 :

Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

C). Both of the above.
D). None of the above is correct.
Answer : Option A

Question 17 :

Each entity is represented as a(n):

A). tuple.
B). table.
C). attribute.
D). file.
Answer : Option B

Question 18 :

For every relationship, how many possible sets of minimum cardinalities are there?

A). Two
B). Three
C). Four
D). Six
Answer : Option C

Question 19 :

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

A). the primary key
B). any alternate key
C). a surrogate key
D). a foreign key
Answer : Option A

Question 20 :

Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

A). Null status
B). Data type
C). Default value
D). Data constraints
Answer : Option D