OLAP is known as online analytical processing which provides answers to queries which are multi dimensional in nature. It composes relational reporting and data mining for providing solutions to business intelligence. This term OLAP is created from the term OLTP.
What is sparsity? a) A condition when each cell of the cube is filled with data and that leads to more processing time. b) A condition when each cell of the cube is not filled with data and that leads to less processing time. c) A condition when each cell of the cube is not filled with data and that leads to more processing time. d) A condition when each cell of the cube is not filled with data.
What is the other name for OLAP cube? a) Multidimensional cube b) Hyper cube c) Cube d) Both 1 and 2
What is OLAP?
What are Cubes in OLAP?
What are Database roles in 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
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
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
