IBM DB2 11 DBA for z/OS 試験
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?