RDBMS

OLAP

Question 1
Marks : +2 | -2
Pass Ratio : 100%
How many dimensions of multi-dimensional data do cross tabs enable analysts to view?
1
2
3
None of the mentioned
Explanation:
Cross-tabs enable analysts to view two dimensions of multi-dimensional data, along with the summaries of the data.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
The _______ function allows substitution of values in an attribute of a tuple
Cube
Unknown
Decode
Substitute
Explanation:
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.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
State true or false: OLAP systems can be implemented as client-server systems
True
False
Explanation:
OLAP systems can be implemented as client-server systems. In fact most of the current OLAP systems are implemented as client-server systems.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What is the full form of OLAP?
Online Application Programming
Online Application Processing
Online Analytical programming
Online Analytical Processing
Explanation:
The full form of OLAP is Online Analytical Processing. It is an interactive system that gives various features to analysts.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
The operation of moving from coarser granular data to finer granular data is called _______
Reduction
Increment
Roll back
Drill down
Explanation:
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.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
The operation of moving from finer granular data to coarser granular data is called _______
Reduction
Increment
Roll up
Drill down
Explanation:
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.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.
True
False
Explanation:
In OLAP, analysts cannot view a dimension in different levels of detail. The different levels of detail are classified into a hierarchy.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
The operation of changing a dimensions used in a cross-tab is called as ________
Alteration
Pivoting
Piloting
Renewing
Explanation:
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.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
Which of the following OLAP systems do not exist?
HOLAP
MOLAP
ROLAP
None of the mentioned
Explanation:
HOLAP means Hybrid OLAP, MOLAP means multidimensional OLAP, ROLAP means relational OLAP. This means all of the above OLAP systems exist.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
Data that can be modelled as dimension attributes and measure attributes are called ___________
Mono-dimensional data
Multi-dimensional data
Measurable data
Efficient data
Explanation:
Data that can be modelled as dimension attributes and measure attributes are called multi-dimensional data.