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.
Ans: Option A
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.
Ans: Option A
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.
Ans: Option C
4. Row is synonymous with the term:
A. record. B. relation.
C. column. D. field.
Ans: Option A
5. The primary key is selected from the:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
Ans: Option C
6. Which of the following is a group of one or more attributes that uniquely identifies a row?
A. Key B. Determinant
C. Tuple D. Relation
Ans: Option A
7. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
A. transitive dependency.
B. insertion anomaly.
C. referential integrity constraint.
D. normal form.
Ans: Option C
8. A relation is considered a:
A. Column.
B. one-dimensional table.
C. two-dimensional table.
D. three-dimensional table.
Ans: Option C
9. In the relational model, relationships between relations or tables are created by using:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
Ans: Option D
10. A functional dependency is a relationship between or among:
A. tables. B. rows.
C. relations. D. attributes.
Ans: Option D
Comments
Post a Comment