IBM Db2 12 for z/OS Administrator 認定 C1000-078 試験問題:

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

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

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

3. Which of the following is TRUE about the SYSCTRL authority?

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

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

5. Which subsystem parameter specifies the action that DB2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement?

A) RLFERRDSTC
B) RLFERRD
C) RLFERR
D) RLFERRSTC

質問と回答：