MCQ on Data Warehouse with Answers set-2

This set of multiple choice question – MCQ on data warehouse includes collections of MCQ questions on fundamental of data warehouse techniques. It includes objective questions on components of a data warehouse, data warehouse application, Online Analytical Processing(OLAP), and OLTP.

1. The full form of OLAP is
A) Online Analytical Processing
B) Online Advanced Processing
C) Online Advanced Preparation
D) Online Analytical Performance

2. ……………………. is a subject-oriented, integrated,time-variant, nonvolatile collection or data in support of management decisions.
A) Data Mining
B) Data Warehousing
C) Document Mining
D) Text Mining

3. The data is stored, retrieved and updated in ………………..
A) OLAP
B) OLTP
C) SMTP
D) FTP

4. An ……………… system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
A) OLAP
B) OLTP
C) Both of the above
D) None of the above

5. …………………… is a good alternative to the star schema.
A) Star schema
B) Snowflake schema
C) Fact constellation
D) Star-snowflake schema

6. The ………………………. exposes the information being captured, stored, and managed by operational systems.
A) top-down view
B) data warehouse view
C) data source view
D) business query view

7. The type of relationship in star schema is ……………
A) many to many
B) one to one
C) one to many
D) many to one

8. The ……………… allows the selection of the relevant information necessary for the data warehouse.
A) top-down view
B) data warehouse view
C) data source view
D) business query view

9. Which of the following is not a component of a data warehouse?
A) Metadata
B) Current detail data
C) Lightly summarized data
D) Component Key

10. Which of the following is not a kind of data warehouse application?
A) Information processing
B) Analytical processing
C) Data mining
D) Transaction processing

Answers:

1. The full form of OLAP is
A) Online Analytical Processing

2. ……………………. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
B) Data Warehousing

3. The data is stored, retrieved and updated in ………………..
B) OLTP

4. An ……………… system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
A) OLAP

5. …………………… is a good alternative to the star schema.
C) Fact constellation

6. The ………………………. exposes the information being captured, stored, and managed by operational systems.
C) data source view

7. The type of relationship in star schema is ……………
C) one to many

8. The ……………… allows the selection of the relevant information necessary for the data warehouse.
A) top-down view

9. Which of the following is not a component of a data warehouse?
D) Component Key

10. Which of the following is not a kind of data warehouse application?
D) Transaction processing

Read Next: Solved MCQ of Data Warehouse set-3