Data Warehouse Architecture MCQs, Data Mining MCQs, IUB Islamia University Bahawalpur, MCQs, COMP-03877 Data Warehousing and Mining MCQs, Multiple Choice Questions
Data Warehouse MCQS with Answer
Multiple Choice Questions.
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. integrated.
D. All of the above.
Answer:
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. Datamarts.
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
