Data Models into Database Designs – General Questions

1. 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?

A. A domain constraint
B. A range constraint
C. An interrelation constraint
D. An interrelation constraint

Correct Answer:  A. A domain constraint

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

A. either table without specifying parent and child tables.
B. the parent table.
C. the child table.
D. either the parent table or the child table.

Correct Answer:  C. the child table.

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

A. Null status
B. Data type
C. Default value
D. Data constraints

Correct Answer:  A. Null status

4. A primary key should be defined as:

A. NULL.
B. NOT NULL.
C. Either of the above can be used.
D. None of the above are correct.

Correct Answer:  B. NOT NULL.

5. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

A. Null status
B. Data type
C. Default value
D. Data constraints

Correct Answer:  B. Data type

Leave A Comment?

two + 16 =