DB2 10 DBA for zOS

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

You have 134 total questions to study from
Each page has 5 questions, making a total of 27 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 21, 2025
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.

Correct Answer: B

Question 2 of 134

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

Append

Inline LOBs

Member cluster

Volatile table

Include columns

Correct Answer: A, C

Question 3 of 134

When is a merge scan join a well performing access path?

When the number of qualifying rows of the inner and outer table are both large.

When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

Correct Answer: A

Question 4 of 134

What trace class will show deadlock information?

Audit class 3.

Statistic class 3.

Accounting class 1.

Performance class 8.

Correct Answer: B

Question 5 of 134

Which DSNZPARM will define the number of RID Blocks in the RID Pool?

NUMTCB

MAXRBLK

CONDBAT

URLGWTH

Correct Answer: B