Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude Page-2 section-1

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

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

17.
Each entity is represented as a(n):

A. tuple.

B. table.

C. attribute.

D. file.

Answer & Solution Discuss in Board Save for Later

18.
For every relationship, how many possible sets of minimum cardinalities are there?

A. Two

B. Three

C. Four

D. Six

Answer & Solution Discuss in Board Save for Later

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

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

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

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

Answer & Solution

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?

Answer & Solution

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

Answer & Solution

14. Which is not true about surrogate keys?

Answer & Solution

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

Answer & Solution

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

Answer & Solution

17. Each entity is represented as a(n):

Answer & Solution

18. For every relationship, how many possible sets of minimum cardinalities are there?

Answer & Solution

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.

Answer & Solution

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?

Answer & Solution

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

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?

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

14.
Which is not true about surrogate keys?

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

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

17.
Each entity is represented as a(n):

18.
For every relationship, how many possible sets of minimum cardinalities are there?

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.

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?