⟩ In SQL the cross-tabs are created using a) Slice b) Dice c) Pivot d) All of the mentioned
a) Slice
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Question and Answer:
Home OLAP
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
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
Can the user perform data-entry or editing tasks on OLAP data? a) Yes b) No
