General Questions

Question 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 : Option A

Question 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 : Option C

Question 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 : Option A

Question 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 : Option B

Question 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 : Option B