Data Models into Database Designs – General Questions

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
Advertisement

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
Advertisement

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.
Advertisement

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.
Advertisement

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
Advertisement

Leave A Comment?