Examice

Exam C2090-616 All QuestionsBrowse all questions from this exam

Go to Exam

Question 38

Which of the following is TRUE about DB2 OLAP functions?

They return scalar values and not array values

There are no DB2 monitor elements specific to OLAP functions

OLAP functions are not supported in a common table expression (CTE)

OLAP aggregation functions are not supported with column organized tables C

Correct Answer:

Discussion

GisahOption: C

C is wrong: Example 5: A common table expression could also have been used. https://www.ibm.com/docs/en/db2/11.1?topic=expressions-olap-specification

db2testerOption: A

The correct answer : A On-Line Analytical Processing (OLAP) functions provide the ability to return ranking, row numbering and existing aggregate function information as a scalar value in a query result. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023461.html