IBM C2090-612 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-612
Exam Name/Title: DB2 10 DBA for z/OS
Certification Provider: IBM
Corresponding Certification: DB2

Exam Questions: 134
Updated On: Jun 02, 2026

Question #19

Which of the following types of table spaces allow multiple tables?

A. Segmented

B. Partition-by-growth

C. Partition-by-range

D. LOB table space

Discussion 0

Correct Answer: A Vote an answer

Question #20

What WLM action will establish performance objectives for DDF threadsand their related address space?

A. Execute the WLM_REFRESH stored procedure for the DDF application environment.

B. Createa WLM service definition that assigns service classes to the DDF threads.

C. Insure the NUMTCB is set to a value greater than 10.

D. Specify DDF for the value of APPLENV to the name of the WLM environment.

Discussion 0

Correct Answer: B Vote an answer

Question #21

In the CFRM policy, what is the purpose of the PREFLIST?

A. To identify all the DB2 members in the group.

B. To identify the preferences for DB2 restart in the event of a disconnection.

C. Toidentify the size of the structure.

D. To identify the preferences for structure rebuild/reallocation during a coupling facility failure.

Discussion 0

Correct Answer: D Vote an answer

Question #22

Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1(COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

A. Compress the tablespace.

B. Copy the index.

C. ALTER the index to use a page size larger than 4K.

D. REBUILD the index.

Discussion 0

Correct Answer: C Vote an answer

Question #23

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

A. Monitor trace class(6)

B. Audit trace class(4)

C. Accounting trace class(1,2,3,7,8)

D. Performance trace class(3)

Discussion 0

Correct Answer: D Vote an answer

Question #24

For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

A. Declared global temporary tables

B. Catalog tables

C. Directory tables

D. Auxiliary tables

Discussion 0

Correct Answer: B Vote an answer

Question #25

Which DB2 online utility job output provides you with information about the BACKUP SYSTEM history?

A. REPORT with RECOVERY option

B. DSNJU004

C. DIAGNOSE

D. DSNJU003

Discussion 0

Correct Answer: A Vote an answer

Question #26

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

A. col2 is converted to EBCDIC

B. col2 and col1 are converted to UTF-32

C. SQLCode-270: Function not supported

D. col1 is converted to UNICODE

Discussion 0

Correct Answer: D Vote an answer

Question #27

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

A. The complete data is storedboth in auxiliary and in base table.

B. The data is only stored in the base table.

C. The data is only stored in the auxiliary table.

D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM C2090-612 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-612 exam.