最新なIBM 000-544問題集（106題）、真実試験の問題を全部にカバー！

質問 1：
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
A. DB2_SET_MAX_CONTAINER_SIZE
B. DB2_LIMIT_AS_CONTAINER_BLOCKS
C. DB2_ALLOCATION_SIZE
D. DB2_TRUNCATE_AS_STORAGE
正解：A

質問 2：
A DBA wants to migrate a DB2 LUW 8.2.2 database to version 9.7 and plans to use currently committed (CC) semantics on an application-by-application basis. Which process will yield the desired results?
A. Set the DB2_USE_CC_SEMANTICS registry variable to YES, then migrate the database.
B. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.
C. Set the DB2_USE_CC_SEMANTICS registry variable to APPLICATION, then migrate the database.
D. Migrate the database, then assign the value ON to the CURR_COMMIT configuration parameter.
正解：B

質問 3：
Which two operators would indicate inter-partition parallelism in an Optimizer Plan? (Choose two.)
A. IP
B. HSJOIN
C. DTQ
D. LTQ
E. BTQ
正解：C,E

質問 4：
How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
A. Use the ALTER INDEX and REORG INDEX commands.
B. Use the DROP INDEX and CREATE INDEX commands.
C. Use the REORG INDEX command.
D. Use the ALTER INDEX command.
正解：B

質問 5：
Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)
A. MAX_AGENTS 100, MAX_CONNECTIONS 2000
B. INTRA_PARALLEL NO
C. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
D. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
E. INTRA_PARALLEL YES
正解：D,E

質問 6：
Which data organization schemes are supported?
A. PARTITION BY RANGE and ORGANIZE BY HASH
B. PARTITION BY HASH and ORGANIZE BY
C. PARTITION BY HASH and ORGANIZE BY RANGE
D. PARTITION BY RANGE and ORGANIZE BY
正解：D

質問 7：
Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?
A. UTIL_HEAP_SZ and DATABASE_MEMORY
B. LOAD_HEAP_SZ and DATABASE_MEMORY
C. UTIL_HEAP_SZ and STAT_HEAP_SZ
D. LOAD_HEAP_SZ and STAT_HEAP_SZ
正解：A

質問 8：
Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?
A. The ADMIN_GET_TAB_INFO table function.
B. The ADMINGETTABCOMPRESSINFO_V97 table function.
C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
D. The ADMINGETTABCOMPRESSINFO table function.
正解：C

質問 9：
Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
A. RECLAIM EXTENTS ONLY
B. RECLAIM FREE BLOCKS
C. RELEASE FREE EXTENTS ONLY
D. RELEASE FREE BLOCKS ONLY
正解：A