Binning process is very useful to save space. Performance may vary depending upon the query generated sometimes solution to a query can come within few seconds and sometimes it may take longer time. Binning process holds multiple values in the same bin.
What do data warehouses support? a) OLAP b) OLTP c) OLAP and OLTP d) Operational databases
{ (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 mentionedIn 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
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."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org