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
Submitted by: Administratorb) 4
Explanation:
{ (item name, color, clothes size), (item name, color), (item name), () }.
Submitted by:
Explanation:
{ (item name, color, clothes size), (item name, color), (item name), () }.
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. |
