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
