MCQ on Data Warehouse with Answers set-2


Data Warehouse Overview
Data Warehouse Overview (Photo credit: Wikipedia)


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