Online analytical processing (OLAP) Question:

Download Job Interview Questions and Answers 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

OLAP Interview Question
OLAP Interview Question

Answer:

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

Download OLAP Interview Questions And Answers PDF

Previous QuestionNext 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])