IBM DB2 11 DBA for z/OS - C2090-312 Exam Questions [2026]

QUESTION NO: 1
What is required before you begin your installation of DB2 11?

A. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format. B. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format. C. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format. D. Data sets for catalog and directory tables must be user-managed.

Correct Answer: D

QUESTION NO: 2
Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?

A. XML column B. Hidden ROWID column C. DOCID column D. LOB column

Correct Answer: A

QUESTION NO: 3
Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?

A. CLASS(1,5,10) B. CLASS(1, 2,3,7,8) C. CLASS(1,2,3) D. CLASS(2,7,8)

Correct Answer: B

QUESTION NO: 4
Which statement is true?

A. Unicode and EBCDIC have a different collating sequence. B. The collating sequence for ASCII and EBCDIC is identical. C. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation. D. The collating sequence for Unicode and EBCDIC is identical.

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
When would DB2 NOT use list prefetch?

A. RUNSTATS TABLESPACE without table sampling. B. Incremental image copies of a table space defined with TRACKMOD YES. C. Fast log apply operations. D. Reading leaf pages of a disorganized index.

Correct Answer: D

QUESTION NO: 6
Which global variables statement is true?

A. Like for special registers, the access to global variables cannot be granted or revoked. B. A global variable is a created DB2 object, which can be instantiated and used by applications. C. A global variable is a synonym for special registers. D. Global variables can only be used in native SQL stored procedures and user-defined functions.

Correct Answer: A

QUESTION NO: 7
When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2'.
What is the result of executing the DDL statement?

A. It is rejected by the database system. B. It is checked against only all existing rows in the table. C. It is checked against only new rows as they are added to the table. D. The table space is placed in CHKP status.

Correct Answer: B