Online analytical processing (OLAP) Question: Download OLAP PDF

What do data warehouses support?
a) OLAP
b) OLTP
c) OLAP and OLTP
d) Operational databases

a) OLAP

Previous Question	Next Question
{ (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	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