Database - Data Models into Database Designs

Exercise : 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 domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
Answer: Option
Explanation:
No answer description is available. Let's discuss.

2.
In a 1:N relationship, the foreign key is placed in:
either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

3.
Which of the following column properties specifies whether or not cells in a column must contain a data value?
Null status
Data type
Default value
Data constraints
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
A primary key should be defined as:
NULL.
NOT NULL.
Either of the above can be used.
None of the above are correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Null status
Data type
Default value
Data constraints
Answer: Option
Explanation:
No answer description is available. Let's discuss.