Data Models into Database Designs - Practice Questions

Question 1

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

Question 2

Which of the following column properties specifies whether or not cells in a column must contain a data value?

Accepted Answer

Question 3

Which is not true about surrogate keys?

Accepted Answer

Question 4

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

Accepted Answer

Question 5

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

Question 6

In a 1:N relationship, the foreign key is placed in:

Accepted Answer

Question 7

In a 1:1 relationship, the foreign key is placed in:

Accepted Answer

Question 8

Which of the following column properties would be used to specify that cells in a column 
must be immediately filled with a monetary value of $10,000?

Accepted Answer

Question 9

Each entity is represented as a(n):

Accepted Answer

Question 10

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

Accepted Answer