Discussion
Home ‣ Database ‣ Introduction to Database Comments
- Question
The following are components of a database except ________ .
Options- A. user data
- B. metadata
- C. reports
- D. indexes
- Correct Answer
- reports
- 1. 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
- 2. 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
- 3. SQL stands for ________ .
Options- A. Structured Query Language
- B. Sequential Query Language
- C. Structured Question Language
- D. Sequential Question Language Discuss
- 4. 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
- 5. Because it contains a description of its own structure, a database is considered to be ________ .
Options- A. described
- B. metadata compatible
- C. self-describing
- D. an application program Discuss
- 6. A relation is considered a:
Options- A. Column.
- B. one-dimensional table.
- C. two-dimensional table.
- D. three-dimensional table. Discuss
- 7. Row is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 8. 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
- 9. 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
- 10. 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
Introduction to Database problems
Search Results
Correct Answer: COBOL programs
Correct Answer: DB2
Correct Answer: Structured Query Language
Correct Answer: multiuser database application
Correct Answer: self-describing
Correct Answer: two-dimensional table.
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.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.