The Relational Model and Normalization problems
- 1. A relation is considered a:
Options- A. Column.
- B. one-dimensional table.
- C. two-dimensional table.
- D. three-dimensional table. Discuss
Correct Answer: two-dimensional table.
- 2. Row is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
Correct Answer: record.
- 3. The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. referential integrity constraints.
- C. functional dependencies.
- D. None of the above is correct. Discuss
Correct Answer: normal forms.
- 4. A relation in this form is free of all modification anomalies.
Options- A. First normal form
- B. Second normal form
- C. Third normal form
- D. Domain/key normal form Discuss
Correct Answer: Domain/key normal form
- 5. One solution to the multivalued dependency constraint problem is to:
Options- A. split the relation into two relations, each with a single theme.
- B. change the theme.
- C. create a new theme.
- D. add a composite key. Discuss
Correct Answer: split the relation into two relations, each with a single theme.
- 6. A relation is in this form if it is in BCNF and has no multivalued dependencies:
Options- A. second normal form.
- B. third normal form.
- C. fourth normal form.
- D. domain/key normal form. Discuss
Correct Answer: fourth normal form.
- 7. If attribute A determines both attributes B and C, then it is also true that:
Options- A. A ? B.
- B. B ? A.
- C. C ? A.
- D. (B,C) ? A. Discuss
Correct Answer: A ? B.
- 8. A tuple is a(n):
Options- A. column of a table.
- B. two dimensional table.
- C. row of a table.
- D. key of a table. Discuss
Correct Answer: row of a table.
- 9. 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:
Options- A. A ? B.
- B. A ? C.
- C. A ? (B,C).
- D. (B,C) ? A. Discuss
Correct Answer: A ? B.
- 10. Which of the following is a group of one or more attributes that uniquely identifies a row?
Options- A. Key
- B. Determinant
- C. Tuple
- D. Relation Discuss
Correct Answer: Key
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.