Data Models into Database Designs MCQs

Question 1

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.

Accepted Answer

the primary key

Answer

any alternate key

Answer

a surrogate key

Answer

a foreign key

Question 2

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?

Accepted Answer

Data constraints

Answer

Null status

Answer

Data type

Answer

Default value

Question 3

A foreign key is used to implement relationships between tables.

Accepted Answer

True

Answer

False

Question 4

The terms alternate key and candidate key mean the same thing.

Accepted Answer

True

Answer

False

Question 5

In 1:N relationships, which entity becomes the parent entity is arbitrary.

Accepted Answer

False

Answer

True

Question 6

When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

Accepted Answer

True

Answer

False

Question 7

In a 1:1 relationship, the primary key placement is arbitrary.

Accepted Answer

True

Answer

False

Question 8

When the parent entity is required, a new child row can always be inserted.

Accepted Answer

False

Answer

True

Question 9

All primary keys are required.

Accepted Answer

True

Answer

False