Free IBM C2090-318 Practice Test & Real Exam Questions

Exam Code/Number: C2090-318
Exam Name/Title: DB2 12 System Administrator for z/OS
Certification Provider: IBM
Corresponding Certification: IBM Data and AI

Exam Questions: 60
Updated On: May 31, 2026

Question #1

Where is recovery information for table space DSNDB06.SYSTSCPY stored?

A. SYSIBM.SYSCOPY

B. Log

C. BSDS

D. Directory

Discussion 0

Correct Answer: A Vote an answer

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

Question #2

The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?

A. Bind more packages using BIND option KEEPDYNAMIC(YES)

B. Reduce the value specified for subsystem parameter EDMSTMTC

C. Reduce the value specified for subsystem parameter MAX_IN_MEMORY

D. Reduce the value specified for subsystem parameter MAXKEEPD

Discussion 0

Correct Answer: D Vote an answer

Question #3

For a general application performance problem, which set of documentation would be most useful for diagnosis?

A. SVC Dump

B. RMF Monitor

C. SMF accounting and statistics traces

D. DIAGNOSE MEPL utility

Discussion 0

Correct Answer: D Vote an answer

Question #4

Which utility must be executed before and after running a REORG utility against a system catalog table space to support recovery?

A. MODIFY

B. CHECK DATA

C. COPY

D. RUNSTATS

Discussion 0

Correct Answer: C Vote an answer

Question #5

DB2 just abended unexpectedly and needs to be restarted as quickly and consistently as possible. Which of the following restart method do you pick?

A. Create a conditional restart record using option STARTRBA and then restart DB2.

B. Create a conditional restart record using option ENDRBA and then restart DB2

C. Issue the-START DB2 command

D. Perform a cold start

Discussion 0

Correct Answer: D Vote an answer

Question #6

In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

A. Time spent rebuilding indexes at disaster site

B. The total number of incremental image copies made

C. The ability to perform a RESTORE SYSTEM

D. The amount of data that could potentially be lost

Discussion 0

Correct Answer: D Vote an answer

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

Download Free IBM C2090-318 Demo

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