C1000-078無料問題集「IBM Db2 12 for z/OS Administrator」

質問 1

Az/OS system has some storage constraints. The results of-DIS
STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes. What can be done to avoid this storage usage?

（A）Reorganize the listed indexes

（B）Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes

（C）Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE

（D）Set subsystem parameter INDEX_CLEANUP_THREADS to 0

正解：D 解答を投票する

質問 2

Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?

（A）The member on which the command is issued must be started in maintenance mode

（B）Only one member may be active when the command is issued

（C）All active members must be running DB2 12

（D）The command must be issued with installation SYSADM authority

正解：B 解答を投票する

質問 3

What are the appropriate actions that can be taken to reduce false contention in a data sharing environment? (Choose two)

（A）Reduce the IRLMRWT subsystem parameter value

（B）Increase the size of the lock structure

（C）Increase the proportional size of the lock table

（D）Use LOCKSIZE PAGE and MAXROWS 1

（E）Increase workload with inter-DB2 read/write interest

正解：A、B 解答を投票する

質問 4

Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

（A）-DISPLAY DATABASE

（B）-ACCESS DATABASE

（C）-STOP DATABASE

（D）-START DATABASE

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 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）RLFERRSTC

（C）RLFERRD

（D）RLFERR

正解：A 解答を投票する

質問 6

Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?

（A）Monitor

（B）Audit

（C）Statistics

（D）Accounting

正解：B 解答を投票する

C1000-078 無料問題集「IBM Db2 12 for z/OS Administrator」

弊社を連絡する

関連リンク

トップ試験