General Questions

Question 11 :

The identifier of an entity will become the ________ of the new table.

A). foreign key
B). main attribute
C). primary key
D). identity key
Answer : Option C

Question 12 :

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

A). A domain constraint
B). A range constraint
C). An intrarelation constraint
D). An interrelation constraint
Answer : Option C

Question 13 :

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

A). primary key.
B). foreign key.
C). composite key.
D). surrogate key.
Answer : Option D

Question 14 :

Which is not true about surrogate keys?

A). They are short.
B). They are fixed.
C). They have meaning to the user.
D). They are numeric.
Answer : Option C

Question 15 :

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

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