DB2 10 DBA for zOS

Here you have the best IBM C2090-612 practice exam questions

You have 134 total questions across 27 pages (5 per page)
These questions were last updated on February 21, 2026
This site is not affiliated with or endorsed by IBM.

Question 1 of 134

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?

NUMTCB parameter must be set to 1 for Java stored procedures.

NUMTCB parameter must be set to 1 for REXX stored procedures.

NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.

NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.

Question 2 of 134

If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

The next sort step will perform two sorts.

There are multiple sorts in the plan step.

One sort in the plan step will accomplish two tasks.

Two sorts are performed on the new table of a star join.

Question 3 of 134

What IBM provided stored procedure will access DB2 real time statistics tables?

DSNAEXP

DSNAIMS

DSNACCOX

DSNLEUSR

Question 4 of 134

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

Filter factor information.

Stage 1 and stage 2 information.

Number of columns used in an index.

Number of times an SQL statement is executed.

Question 5 of 134

Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

About the IBM C2090-612 Certification Exam

About the Exam

The IBM C2090-612 (DB2 10 DBA for zOS) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 134 practice questions across 27 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our C2090-612 questions are regularly updated to reflect the latest exam objectives.