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

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home OLAP

⟩ 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

b) 4

Explanation:

{ (item name, color, clothes size), (item name, color), (item name), () }.

Is this answer helpful?
1 Yes | 0 No

256 views

More Questions for you:

Where is Data Sources in OLAP?

What are Fact Tables?

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

Which of the following below is/are OLAP vendors?
a) Cognos
b) Infor
c) Oracle corporation
d) All of the above

Data that can be modeled as dimension attributes and measure attributes are called _______ data.
a) Multidimensional
b) Singledimensional
c) Measured
d) Dimensional

Explain about the database marketing application of OLAP?

Explain about multidimensional features present in OLAP?

Explain about analysis?

What are the different industries which use this marketing tool?

Explain about shared features of OLAP?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home OLAP

⟩ 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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home OLAP

⟩ 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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: