Online analytical processing (OLAP) Question:

Download Job Interview Questions and Answers PDF

{ (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

OLAP Interview Question
OLAP Interview Question

Answer:

d) None of the mentioned
Explanation:
'Group by cube' is used .

Download OLAP Interview Questions And Answers PDF

Previous QuestionNext Question
In SQL the cross-tabs are created using:
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
What do data warehouses support?
a) OLAP
b) OLTP
c) OLAP and OLTP
d) Operational databases