Online analytical processing (OLAP) Question: Download OLAP PDF

In SQL the cross-tabs are created using:
a) Slice
b) Dice
c) Pivot
d) All of the mentioned

a) Slice
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).

Previous Question	Next Question
The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________. a) Roll-up b) Drill down c) Dicing d) Pivoting	{ (item name, color, clothes size), (item name, color), (item name, clothes size), (color, clothes size), (item name), (color), (clothes size), () } 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