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

IBM C2090-312 問題練習

IBM DB2 11 DBA for z/OS 試験

最新更新時間: 2020/11/18,合計20問。

いい買物の日:C2090-312 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

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

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

 / 2

Question No : 1
What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?

正解:

Question No : 2
A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?

正解:

Question No : 3
You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB.
How would you find this information?

正解:

Question No : 4
Which component is NOT shared between DB2 data sharing members?

正解:

Question No : 5
You want to create a table space without actually creating the underlying data sets until rows are inserted into the corresponding table.
Which CREATE TABLESPACE statement option and value should you use?

正解:

Question No : 6
An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID.
What other DB2 supplied information could be reviewed to learn more about the updated data?

正解:

Question No : 7
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?

正解:

Question No : 8
Which global variables statement is true?

正解:

Question No : 9
The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?

正解:

Question No : 10
Which command populates the EXPLAIN tables but does not create a package?

正解:
Explanation: http://www01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ bindoptexplain.dita

Question No : 11
What is necessary in order to enable optimization hints?

正解:

Question No : 12
If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:
BIND QUERY LOOKUP (YES)
what is the result of the execution of this command?

正解:
Explanation: http://www01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ cmd_bindquery.dita?cp=SSEPEK_11.0.0%2F10-1-1-0-0-2

Question No : 13
A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?

正解:

Question No : 14
Prefetch l/Os are executed under a service request block in which address space?

正解:

Question No : 15
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?

正解:

 / 2