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

Home / Database / Data Models Into Database Designs

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

Answer & Solution Discuss in Board Save for Later

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.

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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.

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8