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


Correct Answer:  C. primary key

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 interrelation constraint
D. An interrelation constraint


Correct Answer:  C. An interrelation constraint

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.


Correct Answer:  D. surrogate key.

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.


Correct Answer:  C. They have meaning to the user.

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

A. Two
B. Three
C. Four
D. Six


Correct Answer:  D. Six

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    11 − one =