General Questions

Question 1 :

The entity integrity rule states that:


A). no primary key attribute may be null.
B). no primary key can be composite.
C). no primary key may be unique.
D). no primary key may be equal to a value in a foreign key.
Answer : Option A

Question 2 :

When mapping a many-to-many unary 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 B

Question 3 :

If no multivalued attributes exist and no partial dependencies 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 B

Question 4 :

A foreign key is which of the following?


A). Any attribute
B). The same thing as a primary key
C). An attribute that serves as the primary key of another relation
D). An attribute that serves no purpose
Answer : Option C

Question 5 :

A transitive dependency is which of the following?


A). A functional dependency between two or more key attributes.
B). A functional dependency between two or more nonkey attributes.
C). A relation that is in first normal form.
D). A relation that is in second normal form.
Answer : Option B