General Questions

Question 1 :

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A). A ? B.
B). A ? C.
C). A ? (B,C).
D). (B,C) ? A.
Answer : Option A

Question 2 :

The different classes of relations created by the technique for preventing modification anomalies are called:

A). normal forms.
B). referential integrity constraints.
C). functional dependencies.
D). None of the above is correct.
Answer : Option A

Question 3 :

A relation is in this form if it is in BCNF and has no multivalued dependencies:

A). second normal form.
B). third normal form.
C). fourth normal form.
D). domain/key normal form.
Answer : Option C

Question 4 :

Row is synonymous with the term:

A). record.
B). relation.
C). column.
D). field.
Answer : Option A

Question 5 :

The primary key is selected from the:

A). composite keys.
B). determinants.
C). candidate keys.
D). foreign keys.
Answer : Option C