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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum