C2090-318 Exam Training Practice Tests (IBM DB2 12 System Administrator for z/OS)]

Question 1

Which of the following migration steps is optional?

A. Define DB2 initialization parameters: DSNTIJUZ B. Tailor the DB2 catalog C. Verify the integrity of the DB2 catalog and directory D. Define DB2 12 to z/OS

Correct Answer: C

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

Question 2

Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

A. Compressed records cannot be printed in decompressed format B. lt can be executed on both image copies and concurrent copies C. lt can be executed when the DB2 subsystem is not operational D. It does not decrypt any encrypted data E. The input can be a list of concatenated DB2 VSAM data sets

Correct Answer: C,D

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

Question 3

Which of the following allows tracking of database administration tasks performed by system DBADMs?

A. Use the DIAGNOSE utility with option TRACEID B. Define and start an appropriate audit policy in SYSIBM.SYSAUDITPOLICIES C. Start the appropriate accounting trace classes and analyze the SMF records D. Use the REPORT utility with option TABLESPACESET

Correct Answer: C

Question 4

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

A. SVC Dump B. SMF accounting and statistics traces C. DIAGNOSE MEPL utility D. RMF Monitor

Correct Answer: C

Question 5

During DB2 restart, it is observed that it takes a significant amount of time to complete. Which of the following could be tuned to improve restart time?

A. Reduce system checkpoint interval B. Specify LBACKOUT=NO C. Specify LOCKSIZE ANY for DB2 objects D. Specify CURRENTDATA(YES)

Correct Answer: A

Question 6

Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?

A. VPPSEQT B. VPSEQT C. DWQT D. VDWQT

Correct Answer: B

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

IBM DB2 12 System Administrator for z/OS - C2090-318 Exam Practice Test