OLAP Interview Question:

Select item name, color, clothes size, sum(quantity)
from sales group by rollup(item name, color, clothes size);
How many grouping is possible in this rollup?
a) 8
b) 4
c) 2
d) 1

Submitted by: Administrator

b) 4
Explanation:
{ (item name, color, clothes size), (item name, color), (item name), () }.
Submitted by: