OLAP MCQ Questions & Answers

OLAP MCQs : This section focuses on "OLAP" of Data Warehousing. 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. OLAP stands for?

A. Offline Analytical Processing Server
B. Online Analysts Processing Server
C. Online Access Processing Server
D. Online Analytical Processing Server

View Answer

2. OLAP based on?

A. one dimensional data model
B. two dimensional data model
C. multidimensional data model
D. All of the above

View Answer

3. How many types of OLAP servers?

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

View Answer

4. _________ uses array-based multidimensional storage engines for multidimensional views of data.


View Answer

5. ROLAP servers are placed between relational back-end server and client front-end tools

C. Can be true or false
D. Can not say

View Answer

6. Which of the following is false about OLAP?

A. Involves historical processing of information
B. Useful in analyzing the business
C. Number or users is in millions
D. Number of records accessed is in millions

View Answer

7. The pivot operation is also known as?

A. dice
B. rotation
C. roll up
D. None of the above

View Answer

8. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.

A. Two dimensional cube
B. Multidimensional cube
C. N-dimensional cube
D. Cuboid

View Answer

9. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is

A. Pivoting
B. Dicing
C. Slicing
D. Roll up

View Answer

10. Roll-up performs aggregation on a data cube.

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

View Answer


* You must be logged in to add comment.