Home / CSE MCQs / DBMS MCQs :: OLAP - DBMS

CSE MCQs :: DBMS MCQs

  1. OLAP stands for
  2. A.
    Online analytical processing
    B.
    Online analysis processing
    C.
    Online transaction processing
    D.
    Online aggregate processing

  3. Data that can be modeled as dimension attributes and measure attributes are called _______ data.
  4. A.
    Multidimensional
    B.
    Singledimensional
    C.
    Measured
    D.
    Dimensional

  5. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
  6. A.
    Two dimensional cube
    B.
    Multidimensional cube
    C.
    N-dimensional cube
    D.
    Cuboid

  7. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
  8. A.
    Slicing
    B.
    Dicing
    C.
    Pivoting
    D.
    Both a and b

  9. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
  10. A.
    Rollup
    B.
    Drill down
    C.
    Dicing
    D.
    Pivoting

  11. In SQL the cross-tabs are created using
  12. A.
    Slice
    B.
    Dice
    C.
    Pivot
    D.
    All of the mentioned

  13. What do data warehouses support?
  14. A.
    OLAP
    B.
    OLTP
    C.
    OLAP and OLTP
    D.
    Operational databases