← Back to exam page

C2090-616 – DB2 11.1 Fundamentals for LUW

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Which of the following is TRUE about DB2 OLAP functions?

Select an option, then click Submit answer.

  • ○

    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
Question 8

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and

requires no permanent storage?

Select an option, then click Submit answer.

  • ○

    View
  • ○

    Alias
  • ○

    Table
  • ○

    Schema
Question 9

Consider the following query and the resulting set of data:

SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’

Result:

If the query below is executed, how many rows will be returned?

SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’

Select an option, then click Submit answer.

  • ○

    0
  • ○

    1
  • ○

    3
  • ○

    5