Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
A relation is considered a:
Options- A. Column.
- B. one-dimensional table.
- C. two-dimensional table.
- D. three-dimensional table.
- Correct Answer
- two-dimensional table.
- 1. The following are components of a database except ________ .
Options- A. user data
- B. metadata
- C. reports
- D. indexes Discuss
- 2. 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
- 3. 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
- 4. SQL stands for ________ .
Options- A. Structured Query Language
- B. Sequential Query Language
- C. Structured Question Language
- D. Sequential Question Language Discuss
- 5. An Enterprise Resource Planning application is an example of a(n) ________ .
Options- A. single-user database application
- B. multiuser database application
- C. e-commerce database application
- D. data mining database application Discuss
- 6. Row is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 7. 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
- 8. 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
- 9. 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
- 10. 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
The Relational Model and Normalization problems
Search Results
Correct Answer: reports
Correct Answer: COBOL programs
Correct Answer: DB2
Correct Answer: Structured Query Language
Correct Answer: multiuser database application
Correct Answer: record.
Correct Answer: normal forms.
Correct Answer: Domain/key normal form
Correct Answer: split the relation into two relations, each with a single theme.
Correct Answer: fourth normal form.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.