Data Warehouses
1. OLAP stands for
A.  Online analytical processing B.  Online analysis processing C.  Online transaction processing D.  Online aggregate processing
2. Data that can be modeled as dimension attributes and measure attributes are called _______ data.
A.  Multidimensional B.  Singledimensional C.  Measured D.  Dimensional
3. tab which is represented visually is ____________ which is also called as data cube.
A.  Two dimensional cube B.  Multidimensional cube C.  N D.  Cuboid
4. tab (Single dimensional) with a fixed value of one attribute is
A.  Slicing B.  Dicing C.  Pivoting D.  Both Slicing and Dicing
5. granularity data to a coarser granularity (by means of aggregation) is called a ________
A.  Rollup B.  Drill down C.  Dicing D.  Pivoting
6. tabs are created using
A.  Slice B.  Dice C.  Pivot D.  All of the mentioned
7. This can be achieved by using which of the following ?
A.  group by rollup B.  group by cubic C.  group by D.  none of the mentioned
8. What do data warehouses support?
A.  OLAP B.  OLTP C.  OLAP and OLTP D.  Operational databases
9. How many grouping is possible in this rollup?
A.  8 B.  4 C.  2 D.  1
10. Which one of the following is the right syntax for DECODE?
A.  DECODE B.  DECODE C.  DECODE D.  DECODE