MCQ on Data Warehouse with Answers set-2

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

About shuseel

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 5 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.