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.


Correct Answer: B. Two relations are created.

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


Correct Answer: A. First normal form

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


Correct Answer: B. An attribute that uniquely identifies each row

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.


Correct Answer: A. data in the form of tables.

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.


Correct Answer: C. Three relations are created.

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 *

    18 + eleven =