C1000-078 Exam Training Practice Tests (IBM Db2 12 for z/OS Administrator)]

Question 1

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

A. CHECK DATA B. RUNSTATS C. COPY D. MODIFY

Correct Answer: B

Question 2

The remote clients are receiving SQLCODE -30062 RDB ACCESS FAILURE, which means access to the database failed because the session data is expired. How can you increase the number of minutes that applications can remain inactive before the associated session data token becomes invalid because of timeout?

A. Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter) B. Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter) C. Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter) D. Issue the -MODIFY DDF SESSIDLE command to increase session timeout

Correct Answer: D

Question 3

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 MAX_IN_MEMORY C. Reduce the value specified for subsystem parameter EDMSTMTC D. Reduce the value specified for subsystem parameter MAXKEEPD

Correct Answer: A

Question 4

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

A. Execute CHECK INDEX on the primary key and foreign key indexes B. Execute the REPAIR utility with SET NOCHECKPEND C. Alter the object to remove any table or referential constraint definitions D. Start the object in question with FORCE to remove any CHECK PENDING status

Correct Answer: D

Question 5

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 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending B. The affected page sets will be put into RESTP restrictive state C. The affected page sets will be put into REFP restrictive state D. DB2 abends

Correct Answer: A

Question 6

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

A. DSN3@SGN B. DSNXRXAC C. DSN3@ATH D. DSNXSXAC

Correct Answer: B

Question 7

Beginning with function level V12R1M500. what would be the maximum data set size of an active log?

A. 255 GB B. 123 GB C. 768 GB D. 4 GB

Correct Answer: A

IBM Db2 12 for z/OS Administrator - C1000-078 Exam Practice Test