Data Warehouse MCQ Questions & Answers

DWH MCQs : This section focuses on "basics" of Data Warehouse. These Multiple Choice Questions (MCQs) should be practiced to improve the Data Warehousing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.

1. The term Data Warehouse was first coined by?

A. Roger Mougalas
B. Arthur Samuel
C. Bill Inmon
D. Herbert Simon

View Answer

2. In Which year, Data Warehouse was first coined?

A. 1987
B. 1988
C. 1989
D. 1990

View Answer

3. Data warehouse is a?

A. subject oriented
B. integrated
C. time-variant
D. All of the above

View Answer

4. How many types of data warehouse there?

A. 2
B. 3
C. 4
D. 5

View Answer

5. A data warehouse does not require transaction processing, recovery, and concurrency controls?

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer

6. ________________ supports knowledge discovery by finding hidden patterns and associations, constructing analytical models, performing classification and prediction.

A. Information Processing
B. Analytical Processing
C. Data mining
D. All of the above

View Answer

7. OLAP contains historical data?

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer

8. To integrate heterogeneous databases, we have ___________ approaches.

A. 1
B. 2
C. 3
D. 4

View Answer

9. Which of the following involves finding and correcting the errors in data?

A. Data Extraction
B. Data Cleaning
C. Data Transformation
D. Data Loading

View Answer

10. Data cleaning and data transformation are important steps in improving the quality of data and data mining results.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer

---

Discussion