IBM C2090-312 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-312
Exam Name/Title: IBM DB2 11 DBA for z/OS
Certification Provider: IBM
Corresponding Certification: IBM Certified Database Administrator

Exam Questions: 67
Updated On: May 30, 2026

Question #8

What is a general recommendation for when to rebind?

A. Before maintenance is applied.

B. After a subsystem restart.

C. After a major change in data volume.

D. After a backup is taken.

Discussion 0

Correct Answer: B Vote an answer

Question #9

Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS DSNV402I _DB2D ACTIVE THREADS NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20172 A51OTEST N* 13 CICSTEST 0125 19625 You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?

A. -CANCEL THREAD(20172)

B. -CANCEL USER(KSTTEST)

C. User KSTTEST does not hold an active connection, no way he blocks anything.

D. -CANCEL THREAD( 3)

Discussion 0

Correct Answer: D Vote an answer

Question #10

Given this statement:
RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH
Which statement is FALSE?

A. It invalidates the dynamic statement cache for table space DB1TS1.

B. It externalizes current access paths statistics for DB1 TS1 to HIST catalog tables.

C. It resets all access path statistics for DB1TS1 in the catalog.

D. It resets all real-time statistics (RTS) for DB1TS1.

Discussion 0

Correct Answer: A Vote an answer

Question #11

A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?

A. The index has now a status of REFP.

B. The index has now a status of RBDP.

C. The index has now a status of CHKP.

D. The index has now a status of RECP.

Discussion 0

Correct Answer: C Vote an answer

Question #12

Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?

A. MONITOR IDLE THREADS

B. MONITOR CONNECTIONS

C. MONITOR ACTIVE THREADS

D. MONITOR THREAD

Discussion 0

Correct Answer: A Vote an answer

Question #13

Which statement is true for data in columns defined with data type XML?

A. Data stored in XML columns cannot be indexed.

B. You can partially UPDATE, DELETE from, and INSERT into an XML document.

C. If you want to change an existing XML document, you have to replace the whole document in the XML column.

D. It is possible to define the XML column with an INLINEJ.ENGTH.

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which statement regarding triggers is true?

A. A trigger can use global variables and change their contents.

B. A trigger can use global variables but cannot change their contents.

C. A trigger cannot use global variables but can change their contents.

D. A trigger cannot use global variables and cannot change their contents.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM C2090-312 Demo

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