General Questions

Question 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

Question 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

Question 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

Question 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

Question 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