Online analytical processing (OLAP) Question: Download OLAP PDF

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

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

Previous Question	Next Question
What do data warehouses support? a) OLAP b) OLTP c) OLAP and OLTP d) Operational databases	Which one of the following is the right syntax for DECODE ? a) DECODE (search, expression, result [, search, result]… [, default]) b) DECODE (expression, result [, search, result]… [, default], search) c) DECODE (search, result [, search, result]… [, default], expression) d) DECODE (expression, search, result [, search, result]… [, default])