IBM Db2 12 for z/OS Administrator (C1000-078) Free Practice Test

Question 1

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 user version of the access control authorization exit routine (DSNX@XAC)

C. The DB2 connection authorization exit routine (DSN3@ATH)

D. The application default load module (DSNHDECP)

Correct Answer: A

Question 2

Which of the following subsystem parameters is only applicable in a data sharing environment?

A. DSMAX

B. RETLWAIT

C. TWOACTV

D. REFSHAGE

Correct Answer: B

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

Question 3

Before execution of the CHECK DATA utility, which of the following should be performed?

A. Alter the object to remove any table or referential constraint definitions

B. Execute CHECK INDEX on the primary key and foreign key indexes

C. Execute the REPAIR utility with SET NOCHECKPEND

D. Start the object in question with FORCE to remove any CHECK PENDING status

Correct Answer: D

Question 4

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

A. -START DYNQUERYCAPTURE

B. -START PROFILE

C. -START TRACE

D. -START RLIMIT

Correct Answer: C

Question 5

Considering the following command:
-CANCEL THREAD {*) FORCE
In which of the following situations can it be used?

A. On application threads that update NOT LOGGED table spaces

B. If the CANCEL THREAD command without the FORCE option does not terminate the thread

C. On local threads that are not in DB2

D. If you are terminating a distributed thread that is part of a global transaction

Correct Answer: B

Question 6

Considering the following command:
-STOP DDF MODE(SUSPEND)
Which of the following, pertaining to DDF connections in a two-way data sharing environment, is TRUE?

A. It suspends DDF threads by preventing the outbound DDF work

B. It stops the DDF on the current member of the data sharing group if DDF has already been started

C. It stops the DDF on all the members of the data sharing group where DDF has already been started

D. It terminates currently executing distributed threads on the current member of the data sharing group

Correct Answer: A

Question 7

For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

A. ACQUIRE(USE)ISOLATION(RR)

B. ACQUIRE(USE)ISOLATION(CS)

C. CURRENTDATA(NO)ISOLATION(CS)

D. CURRENTDATA(YES) ISOLATION(CS)

Correct Answer: C

Welcome to TestSimulate

IBM Db2 12 for z/OS Administrator (C1000-078) Free Practice Test