IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 23

Which of the following is TRUE about DB2 OLAP functions?

Answer options

• A. They return scalar values and not array values
• B. There are no DB2 monitor elements specific to OLAP functions
• C. OLAP functions are not supported in a common table expression (CTE)
• D. OLAP aggregation functions are not supported with column organized tables C

Correct answer:

Explanation

The correct answer is A because DB2 OLAP functions indeed return scalar values, which distinguishes them from array-returning functions. Option B is incorrect as there are specific monitor elements for OLAP functions in DB2. Option C is also false because OLAP functions can be utilized within common table expressions. Lastly, option D is misleading; while OLAP aggregation functions can be tricky with column organized tables, they are not entirely unsupported.