Online analytical processing (OLAP) Question:
Download Job Interview Questions and Answers PDF
In SQL the cross-tabs are created using:
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
![OLAP Interview Answer OLAP Interview Question](https://globalguideline.com/public/images/interview/3.png)
Answer:
a) Slice
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Download OLAP Interview Questions And Answers
PDF