Database - Logical Database Design
Exercise :: Logical Database Design - General Questions
6. |
When mapping a multivalued attribute into a relation which of the following is true? |
A. |
One relation is created. | B. |
Two relations are created. | C. |
Three relations are created. | D. |
Four relations are created. |
Answer: Option B
Explanation:
|
7. |
If no multivalued attributes exist in a relation, then the relation is in what normal form? |
A. |
First normal form | B. |
Second normal form | C. |
Third normal form | D. |
Fourth normal form |
Answer: Option A
Explanation:
|
8. |
A primary key is which of the following? |
A. |
Any attribute | B. |
An attribute that uniquely identifies each row | C. |
An attribute that uniquely identifies each column | D. |
A derived attribute |
Answer: Option B
Explanation:
|
9. |
The relational model consists of: |
A. |
data in the form of tables. | B. |
data redundancy. | C. |
operations using non-SQL languages. | D. |
unorganized data. |
Answer: Option A
Explanation:
|
10. |
When mapping a binary many-to-many relationship into a relation which of the following is true? |
A. |
One relation is created. | B. |
Two relations are created. | C. |
Three relations are created. | D. |
Four relations are created. |
Answer: Option C
Explanation:
|