Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude

Home / Database / Data Models Into Database Designs

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 & Solution Discuss in Board Save for Later

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 & Solution Discuss in Board Save for Later

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 & Solution Discuss in Board Save for Later

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 & Solution Discuss in Board Save for Later

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 & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8