RDBMS Multiple Choice Questions on “OLAP”.
1. What is the full form of OLAP?
a) Online Application Programming
b) Online Application Processing
c) Online Analytical programming
d) Online Analytical Processing
Answer: d
Clarification: The full form of OLAP is Online Analytical Processing. It is an interactive system that gives various features to analysts.
2. Data that can be modelled as dimension attributes and measure attributes are called ___________
a) Mono-dimensional data
b) Multi-dimensional data
c) Measurable data
d) Efficient data
Answer: b
Clarification: Data that can be modelled as dimension attributes and measure attributes are called multi-dimensional data.
3. The operation of changing a dimensions used in a cross-tab is called as ________
a) Alteration
b) Pivoting
c) Piloting
d) Renewing
Answer: b
Clarification: We can change the dimensions used in a cross tab. The operation of changing a dimensions used in a cross-tab is called as pivoting.
4. The operation of moving from finer granular data to coarser granular data is called _______
a) Reduction
b) Increment
c) Roll up
d) Drill down
Answer: c
Clarification: OLAP systems permit users to view the data at any level of granularity. The process of moving from finer granular data to coarser granular data is called as roll-up.
5. How many dimensions of multi-dimensional data do cross tabs enable analysts to view?
a) 1
b) 2
c) 3
d) None of the mentioned
Answer: b
Clarification: Cross-tabs enable analysts to view two dimensions of multi-dimensional data, along with the summaries of the data.
6. The _______ function allows substitution of values in an attribute of a tuple
a) Cube
b) Unknown
c) Decode
d) Substitute
Answer: c
Clarification: The decode function allows substitution of values in an attribute of a tuple. The decode function does not always work as we might like for null values because predicates on null values evaluate to unknown.
7. Which of the following OLAP systems do not exist?
a) HOLAP
b) MOLAP
c) ROLAP
d) None of the mentioned
Answer: d
Clarification: HOLAP means Hybrid OLAP, MOLAP means multidimensional OLAP, ROLAP means relational OLAP. This means all of the above OLAP systems exist.
8. State true or false: OLAP systems can be implemented as client-server systems
a) True
b) False
Answer: a
Clarification: OLAP systems can be implemented as client-server systems. In fact most of the current OLAP systems are implemented as client-server systems.
9. The operation of moving from coarser granular data to finer granular data is called _______
a) Reduction
b) Increment
c) Roll back
d) Drill down
Answer: d
Clarification: OLAP systems permit users to view the data at any level of granularity. The process of moving from finer granular data to coarser granular data is called as drill-down.
10. State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.
a) True
b) False
Answer: b
Clarification: In OLAP, analysts cannot view a dimension in different levels of detail. The different levels of detail are classified into a hierarchy.
Global Education & Learning Series – RDBMS.
To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.
Participate in the Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!