In SQL the cross-tabs are created using:
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
Submitted by: Administratora) Slice
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Submitted by:
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Submitted by:
Read Online OLAP Job Interview Questions And Answers
Top OLAP Questions
| ☺ | Explain about OLAP? |
| ☺ | What is ROLAP? |
| ☺ | Explain about the database marketing application of OLAP? |
| ☺ | Explain about aggregations? |
| ☺ | Explain about MOLAP? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | WPF Interview Questions. |
