← Back to exam page

C2090-320 – DB2 11 Fundamentals for z/OS

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which authorizations can change the value of the subsystem parameter SYSADM using the –SET

SYSPARM command? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    SYSADM
  • ○

    SECADM
  • ○

    SYSCTRL
  • ○

    Installation SYSADM
  • ○

    Installation SYSOPR
Question 2

Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    MAXPARTITIONS
  • ○

    ENDING AT clause on a CREATE INDEX statement for the table
  • ○

    MEMBER CLUSTER
  • ○

    ENDING AT clause on the CREATE TABLE statement
  • ○

    A LOB column specified as a column of the partitioning key
Question 3

Given the following INDEX definition, which attributes apply to this index? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The index is partitioned
  • ○

    The index data sets are user-managed
  • ○

    The index data sets are DB2-managed
  • ○

    The index is unique and in ascending order
  • ○

    The maximum total size of the index is 1 GB