DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
which operation selects one particular dimension from a given cube and provides a new sub-cube.
|
|
Slice
|
|
|
Dice
|
|
|
Rollup
|
|
|
Drill down
|
Explanation:
Detailed explanation-1: -Slice. The slice operation selects one particular dimension from a given cube and provides a new sub-cube.
Detailed explanation-2: -Slice and dice: The slice operation performs a selection on one dimension of the given cube, resulting in a subcube.
Detailed explanation-3: -So, the Slice operations perform a selection on one dimension of the given cube, thus resulting in a subcube.
Detailed explanation-4: -Slice − It describes the subcube to get more specific information. This is performed by selecting one dimension. Dice − It describes the subcube by performing selection on two or more dimensions. Roll-up − The roll-up enables the user to summarise information into a higher general level in the hierarchy.
There is 1 question to complete.