Online analytical processing (OLAP) Question: Download OLAP PDF

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])

d) DECODE (expression, search, result [, search, result]… [, default])

Previous Question	Next Question
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	Data that can be modeled as dimension attributes and measure attributes are called _______ data. a) Multidimensional b) Singledimensional c) Measured d) Dimensional