Data Models Into Database Designs - Study Mode

Show All Answers

[#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 intrarelation 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