Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
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.
- Correct Answer
- normal forms.
- 1. Row is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 2. A relation is considered a:
Options- A. Column.
- B. one-dimensional table.
- C. two-dimensional table.
- D. three-dimensional table. Discuss
- 3. The following are components of a database except ________ .
Options- A. user data
- B. metadata
- C. reports
- D. indexes Discuss
- 4. Which of the following is not considered to be a basic element of an enterprise-class database system?
Options- A. Users
- B. Database applications
- C. DBMS
- D. COBOL programs Discuss
- 5. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
Options- A. IDMS
- B. DB2
- C. dBase-II
- D. R:base Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
The Relational Model and Normalization problems
Search Results
Correct Answer: record.
Correct Answer: two-dimensional table.
Correct Answer: reports
Correct Answer: COBOL programs
Correct Answer: DB2
Correct Answer: Domain/key normal form
Correct Answer: split the relation into two relations, each with a single theme.
Correct Answer: fourth normal form.
Correct Answer: A ? B.
Correct Answer: row of a table.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.