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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    five × one =