IBM Db2 12 for z/OS Administrator - C1000-078 Exam Questions [2026]

QUESTION NO: 1
Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system?

A. SYSOTHER B. SYSTEM C. SYSSTC D. ONLINE

Correct Answer: C

QUESTION NO: 2
Which one of the following modules, or its equivalent name, is optional for a successful DB2 start?

A. The default load module (DSNZPARM) B. The application default load module (DSNHDECP) C. The user version of the access control authorization exit routine (DSNX@XAC) D. The DB2 connection authorization exit routine (DSN3@ATH)

Correct Answer: A

QUESTION NO: 3
Given the following scenario: A table has been dropped accidentally and you need to restore the object. DSN1COPY will be used to restore the object but the PSID and the original OBID of the object is not known. Which stand alone utility will allow you to retrieve that information?

A. DSN1SDMP B. DSN1LOGP C. DSN1PRNT D. DSNJLOGF

Correct Answer: A

QUESTION NO: 4
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. Specify LOCKSIZE ANY for DB2 objects B. Specify CURRENTDATA(YES) C. Specify LBACKOUT=NO D. Reduce system checkpoint interval

Correct Answer: D

QUESTION NO: 5
Which lEAOPTxx parameter and value determines that processes will be routed from zllP to general processors when the zllP engines have no more capacity?

A. IFAHONORPRIORITY = NO B. IFAHONORPRIORITY = YES C. IIPHONORPRIORITY = NO D. IIPHONORPRIORITY = YES

Correct Answer: A

QUESTION NO: 6
Which of the following is TRUE about the SYSCTRL authority?

A. It is designed so group privileges cannot be granted to SYSCTRL B. It is designed to be an administrator in a system with sensitive data C. It is designed not to be a part of the administrative authorizations D. It is designed to allow access to all data directly in DB2

Correct Answer: B

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

QUESTION NO: 7
To initiate a system checkpoint without modifying the current LOGLOAD value, which of the following should be issued?

A. -SET LOG BOTH B. -SET LOG BOTH CHKTIME(10) LOGLOAD(500000) C. -SETLOGLOGLOAD(O) D. -SET LOG RESUME

Correct Answer: C