1. |
__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions. |
A. | Data Mining |
B. | Data Warehousing |
C. | Web Mining |
D. | Text Mining |
Answer» B. Data Warehousing |
2. |
The data Warehouse is __________. |
A. | Read only |
B. | Write only |
C. | Read write only |
D. | None |
Answer» A. Read only |
3. |
Expansion for DSS in DW is _________. |
A. | Decision Support system |
B. | Decision Single System |
C. | Data Storable System |
D. | Data Support System |
Answer» A. Decision Support system |
4. |
The important aspect of the data warehouse environment is that data found within the data warehouse is__________. |
A. | subject-oriented |
B. | time-variant |
C. | integrate |
D. | D All of the above |
Answer» D. D All of the above |
5. |
The time horizon in Data warehouse is usually__________. |
A. | 1-2 years |
B. | 3-4years |
C. | 5-6 years |
D. | 5-10 years |
Answer» D. 5-10 years |
6. |
The data is stored, retrieved & updated in___________. |
A. | OLAP |
B. | OLTP |
C. | SMTP |
D. | FTP |
Answer» B. OLTP |
7. |
__________describes the data contained in the data warehouse. |
A. | Relational data |
B. | Operational data |
C. | Metadata |
D. | Informational data |
Answer» C. Metadata |
8. |
__________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions. |
A. | Data warehouse |
B. | Data mining |
C. | Data marts |
D. | Metadata |
Answer» B. Data mining |
9. |
_________is the heart of the warehouse. |
A. | Data mining database servers |
B. | Data warehouse database servers |
C. | Data mart database servers |
D. | Relational data base servers |
Answer» B. Data warehouse database servers |
10. |
_________is the specialized data warehouse database. |
A. | Oracle |
B. | DBZ |
C. | Informix |
D. | Redbrick |
Answer» D. Redbrick |
11. |
___________defines the structure of the data held in operational databases and used by operational applications. |
A. | User-level metadata |
B. | Data warehouse metadata |
C. | Operational metadata |
D. | Data mining metadata |
Answer» C. Operational metadata |
12. |
_________is held in the catalog of the warehouse database system. |
A. | Application level metadata |
B. | Algorithmic level metadata |
C. | Departmental level metadata |
D. | Core warehouse metadata |
Answer» B. Algorithmic level metadata |
13. |
__________maps the core warehouse metadata to business concepts, familiar and useful to end users. |
A. | Application level metadata |
B. | User level metadata |
C. | Enduser level metadata |
D. | Core level metadata |
Answer» A. Application level metadata |
14. |
____________ consists of formal definitions, such as a COBOL layout or a database schema. |
A. | Classical metadata |
B. | Transformation metadata |
C. | Historical metadata |
D. | Structural metadata |
Answer» A. Classical metadata |
15. |
________consists of information in the enterprise that is not in classical form. |
A. | Mushy metadata |
B. | Differential metadata |
C. | Data warehouse |
D. | Data mining |
Answer» A. Mushy metadata |
16. |
________ Databases are owned by particular departments or business groups. |
A. | Informational |
B. | Operational |
C. | Both informational and operational |
D. | Flat |
Answer» B. Operational |
17. |
The star schema is composed of __________ fact table. |
A. | one |
B. | Two |
C. | Three |
D. | four |
Answer» A. one |
18. |
The time horizon in operational environment is ________. |
A. | 30-60 days |
B. | 60-90 days |
C. | 90-120 days |
D. | 120-150 days |
Answer» B. 60-90 days |
19. |
The key used in operational environment may not have an element of _________. |
A. | Time |
B. | Cost |
C. | Frequency |
D. | Quality |
Answer» A. Time |
20. |
Data can be updated in ______ environment. |
A. | Data warehouse |
B. | Data mining |
C. | Operational |
D. | Informational |
Answer» C. Operational |
21. |
Record cannot be updated in__________. |
A. | OLTP |
B. | Files |
C. | RDBMS |
D. | data warehouse |
Answer» D. data warehouse |
22. |
The source of all data warehouse data is the__________. |
A. | Operational environment |
B. | Informal environment |
C. | Formal environment |
D. | Technology environment |
Answer» A. Operational environment |
23. |
Data warehouse contains ______data that is never found in the operational environment. |
A. | Normalized |
B. | Informational |
C. | Summary |
D. | Denormalized |
Answer» C. Summary |
24. |
The modern CASE tools belong to_________category. |
A. | Analysis |
B. | Development |
C. | Coding |
D. | Delivery |
Answer» A. Analysis |
25. |
Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process. |
A. | 10 percent |
B. | 20 percent |
C. | 30 percent |
D. | 40 percent |
Answer» D. 40 percent |
We're developing a website for study materials for students.
We would love to hear your answers to some of the questions.