General Questions

Question 16 :

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


A). MUST COVER
B). MUST NOT
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