Free C1000-078 Questions for IBM Db2 12 for z/OS Administrator C1000-078 Exam as PDF & Practice Test Engine

Exam Code/Number: C1000-078
Exam Name/Title: IBM Db2 12 for z/OS Administrator
Certification Provider: IBM
Corresponding Certification: IBM Certified Administrator

Exam Questions: 62
Updated On: Aug 20, 2026

Question #1

When must the IRLM address space be active?

A. During start of DB2

B. At the first lock request

C. After startup of DB2

D. At the first concurrent lock situation

Discussion 0

Correct Answer: D Vote an answer

Question #2

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

A. Compressed records cannot be printed in decompressed format

B. The input can be a list of concatenated DB2 VSAM data sets

C. It does not decrypt any encrypted data

D. lt can be executed when the DB2 subsystem is not operational

E. lt can be executed on both image copies and concurrent copies

Discussion 0

Correct Answer: C Vote an answer

Question #3

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

A. BSDS

B. Log

C. SYSIBM.SYSCOPY

D. Directory

Discussion 0

Correct Answer: A Vote an answer

Question #4

Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

A. SYSCTRL

B. Installation SYSOPR

C. Installation SYSADM

D. SYSADM

Discussion 0

Correct Answer: B Vote an answer

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

Question #5

Which DB2 command is used to turn on the recording of CPU usage information for a package?

A. -START DYNQUERYCAPTURE

B. -START TRACE

C. -START PROFILE

D. -START RLIMIT

Discussion 0

Correct Answer: B Vote an answer

Question #6

One DB2 catalog page set is corrupt and needs to be recovered to current. Which of the following is TRUE?

A. The catalog always needs to be recovered as a whole in a certain order

B. Only the corrupt page set needs to be recovered

C. The catalog and directory always needs to be recovered as a whole in a certain order

D. The corrupt page set, and all of the page sets that are required prior to this, must be recovered in a certain order

Discussion 0

Correct Answer: A Vote an answer

Question #7

While processing a DB2 must-complete function, DB2 encountered an error during an attempt to access the required log data sets. Which of the following is TRUE?

A. DB2 abends

B. The affected page sets will be put into REFP restrictive state

C. The affected page sets will be put into RESTP restrictive state

D. DB2 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending

Discussion 0

Correct Answer: D Vote an answer

Free C1000-078 Questions for IBM Db2 12 for z/OS Administrator C1000-078 Exam as PDF & Practice Test Engine

Download Free IBM C1000-078 Demo