⟩ What is the other name for OLAP cube? a) Multidimensional cube b) Hyper cube c) Cube d) Both 1 and 2
d) Both 1 and 2
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
Data that can be modeled as dimension attributes and measure attributes are called _______ data. a) Multidimensional b) Singledimensional c) Measured d) Dimensional
Explain about the database marketing application of OLAP?