Olap(Engineering > Computer Science And Engineering > Dbms Questions And Answers ) Questions and Answers

Question 1. OLAP stands for
  1.    Online analytical processing
  2.    Online analysis processing
  3.    Online transaction processing
  4.    Online aggregate processing
Explanation:-
Answer: Option A. -> Online analytical processing


Online analytical processingOLAP is the manipulation of information to support decision making


Question 2. Data that can be modeled as dimension attributes and measure attributes are called _______ data.
  1.    Multidimensional
  2.    Singledimensional
  3.    Measured
  4.    Dimensional
Explanation:-
Answer: Option A. -> Multidimensional


MultidimensionalGiven a relation used for data analysis, we can identify some of its attributes as measure attributes, since they measure some value, and can be aggregated upon.Dimension attribute define the dimensions on which measure attributes, and summaries of measure attributes, are viewed.


Question 3. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
  1.    Rollup
  2.    Drill down
  3.    Dicing
  4.    Pivoting
Explanation:-
Answer: Option A. -> Rollup


RollupThe opposite operation”that of moving fromcoarser-granularity data to finer-granularity data”is called a drill down.


Question 4. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
  1.    Two dimensional cube
  2.    Multidimensional cube
  3.    N-dimensional cube
  4.    Cuboid
Explanation:-
Answer: Option A. -> Two dimensional cube


Two dimensional cubeEach cell in the cube is identified for the values for the three dimensional attributes.


Question 5. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
  1.    Slicing
  2.    Dicing
  3.    Pivoting
  4.    Both a and b
Explanation:-
Answer: Option D. -> Both a and b


Both a and bFor eg., The item name and colour is viewed for a fixed size.


Question 6. In SQL the cross-tabs are created using
  1.    Slice
  2.    Dice
  3.    Pivot
  4.    All of the mentioned
Explanation:-
Answer: Option A. -> Slice


Slicepivot (sum(quantity) for color in ('dark','pastel','white')) .


Question 7. What do data warehouses support?
  1.    OLAP
  2.    OLTP
  3.    OLAP and OLTP
  4.    Operational databases
Explanation:-
Answer: Option A. -> OLAP


OLAP


© Lakshya_Education.com, All Right Reserved.
Contact Us services