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

RenDC

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

Question and Answer:

Home OLAP

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

d) None of the mentioned

Explanation:

'Group by cube' is used .

Is this answer helpful?
0 Yes | 0 No

225 views

More Questions for you:

In SQL the cross-tabs are created using
a) Slice
b) Dice
c) Pivot
d) All of the mentioned

The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
a) Roll-up
b) Drill down
c) Dicing
d) Pivoting

Explain about candidate check?

The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
a) Two dimensional cube
b) Multidimensional cube
c) N-dimensional cube
d) Cuboid

The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is.
a) Slicing
b) Dicing
c) Pivoting
d) Both a and b

OLAP stands for
a) Online analytical processing
b) Online analysis processing
c) Online transaction processing
d) Online aggregate processing

It is because of __________ that enables OLAP to achieve great performance for a query.
a) Aggregation
b) Composition
c) Dice
d) Hybrid

_____operation of OLAP provides alternate presentation of data by rotating it.
a) Slice
b) Roll up
c) Dice
d) Pivot

What is the source of the OLAP cube's metadata?
a) Star schema
b) Snow flake schema
c) Both a and b
d) Database

Aggregations are built from the _________________ by changing the granularity on specific dimensions.
a) Both c and d below
b) schema
c) Dimension table
d) Fact table

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

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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home OLAP

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

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: