Data Models Into Database Designs(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
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?
An intrarelation constraint
A range constraint
An interrelation constraint
A domain constraint
Explanation:-
Answer: Option D. -> A domain constraint
Question 2. A primary key should be defined as:
None of these
Either of the above can be used.
NULL.
NOT NULL.
Explanation:-
Answer: Option D. -> NOT NULL.
Question 3. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Default value
Data constraints
Data type
Null status
Explanation:-
Answer: Option C. -> Data type
Question 4. Which of the following column properties specifies whether or not cells in a column must contain a data value?
Data type
Data constraints
Null status
Default value
Explanation:-
Answer: Option C. -> Null status
Question 5. In a 1:N relationship, the foreign key is placed in:
the child table.
either the parent table or the child table.
the parent table.
either table without specifying parent and child tables.
Explanation:-
Answer: Option A. -> the child table.
Question 6. In a 1:1 relationship, the foreign key is placed in:
either table without specifying parent and child tables.
either the parent table or the child table.
the child table.
the parent table.
Explanation:-
Answer: Option A. -> either table without specifying parent and child tables.
Question 7. A foreign key is:
used to define data types.
All of these
a column containing the primary key of another table.
used to define null status.
Explanation:-
Answer: Option C. -> a column containing the primary key of another table.
Question 8. Which of the following situation requires the use of ID-dependent entities?
Archetype/instance relationships only
Multivalued attributes only
All of these
Association relationships only
Explanation:-
Answer: Option C. -> All of these
Question 9. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Data type
Data constraints
Default value
Null status
Explanation:-
Answer: Option C. -> Default value
Question 10. Which of the following columns is(are) are required in a table?