IT認証試験問題集
毎月、GOWUKAKUは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / C2090-318 問題集  / C2090-318 問題練習

IBM C2090-318 問題練習

DB2 12 System Administrator for z/OS 試験

最新更新時間: 2024/03/19,合計60問。

【2024年3月キャンペーン】:C2090-318 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、C2090-318 問題集を使用してください。

 / 2

Question No : 1
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?

正解:

Question No : 2
Which of the following migration steps is optional?

正解:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_runlinkch kr.html

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

正解:

Question No : 4
Which library contains the early code for DB2 12?

正解:
Explanation:
The link list look-aside address space (LLA), which contains the Db2 12 early (ERLY) code from the SDSNLINK load module library. https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_refreshdb2zosmigr.html

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

正解:

Question No : 6
CPU utilization for a DB2 subsystem suddenly increased by approximately 20% and is still at this high level after 24 hours. No increase in workload was expected.
What would be the most efficient analysis to perform?

正解:

Question No : 7
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?

正解:
Explanation:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_reco vercatalogdirectoryobjects.html
Use the following general guidelines for all of the steps in this task:
✑ If you copy your catalog or directory indexes, use the RECOVER utility to recover your indexes. Otherwise, use the REBUILD INDEX utility to rebuild those indexes.
✑ For all catalog and directory table spaces, you can list the IBM®-defined indexes that have the COPY YES attribute in the same RECOVER utility statement.
✑ Recovery of the items in the list can be done concurrently or included in the same job step. However, the following restrictions apply:

Question No : 8
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?

正解:

Question No : 9
Which of the following utilities would produce information needed to identify UNDO information for a transaction?

正解:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/pdf/db2z_12_ugrefbook.p df

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

正解:

Question No : 11
Which stored procedures need to be set up in order to register an XML schema?

正解:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/ doc/c0022711.html
When a database is created, the stored procedures used to register XML schemas are also created. To register XML schemas through the stored procedure method, invoke the XSR_REGISTER, XSR_ADDSCHEMADOC and XSR_COMPLETE stored procedures with the CALL statement.

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

正解:
Explanation:
Accounting traceThe accounting trace records transaction-level data that is written when the processing for a transaction is completed. It provides data that enables you to conduct DB2 capacity planning and to tune application programs.
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/perf/src/tpc/db2z_tracetyp es.html

Question No : 13
Which of the following is TRUE about the SYSCTRL authority?

正解:
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/seca/src/tpc/db2z_sysctrla uthority.html
The SYSCTRL authority is designed for administering a system that contains sensitive data. With the SYSCTRL authority, you have nearly complete control of
the DB2® subsystem. However, you cannot access user data directly unless you are explicitly granted the privileges to do so.

Question No : 14
At what point in the upgrade process is the catalog migrated to DB2 12?

正解:

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

正解:

 / 2