843 お客様のコメント
質問 1：
What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?
A. check semantics; parse query; rewrite query; build access plan
B. check semantics; parse query; build access plan; pushdown predicates; execute access plan
C. parse query; rewrite query; check semantics; pushdown predicates; execute access plan
D. parse query; check semantics; rewrite query; build access plan
正解：D
質問 2：
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
質問 3：
Which command will prevent prefetching during crash recovery?
A. db2set DB2_RECOVERY_PREFETCHING=YES
B. db2set DB2_AVOID_PREFETCH=ON
C. db2set DB2_AVOID_PREFETCH=OFF
D. db2set DB2_RECOVERY_PREFETCHING=NO
正解：B
質問 4：
A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?
A. UPDATE DBM CFG USING NUM_POOLAGENTS 0;
db2stop;
db2start;
B. UPDATE DBM CFG USING NUM_INITAGENTS 200;
db2stop;
db2start;
C. UPDATE DBM CFG USING NUM_POOLAGENTS 200;
db2stop;
db2start;
D. UPDATE DBM CFG USING NUM_INITAGENTS 0;
db2stop;
db2start;
正解：C
質問 5：
Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?
A. VOLATILE
B. CARDINALITY VOLATILE
C. CURRENT CARDINALITY
D. INDEXSCAN
正解：A
質問 6：
Which action can be performed by the ALTER TABLESPACE statement?
A. Add a container to an SMS table space on a database partition that currently has no containers.
B. Change an SMS table space to a DMS table space on any database partition.
C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
D. Change the size of a container in an SMS table space.
正解：A
質問 7：
What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?
A. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table
B. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Rebind the partitioned table
C. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Reorg the partitioned table
D. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Update statistics on the partitioned table
正解：A
What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?
A. check semantics; parse query; rewrite query; build access plan
B. check semantics; parse query; build access plan; pushdown predicates; execute access plan
C. parse query; rewrite query; check semantics; pushdown predicates; execute access plan
D. parse query; check semantics; rewrite query; build access plan
正解：D
質問 2：
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
質問 3：
Which command will prevent prefetching during crash recovery?
A. db2set DB2_RECOVERY_PREFETCHING=YES
B. db2set DB2_AVOID_PREFETCH=ON
C. db2set DB2_AVOID_PREFETCH=OFF
D. db2set DB2_RECOVERY_PREFETCHING=NO
正解：B
質問 4：
A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?
A. UPDATE DBM CFG USING NUM_POOLAGENTS 0;
db2stop;
db2start;
B. UPDATE DBM CFG USING NUM_INITAGENTS 200;
db2stop;
db2start;
C. UPDATE DBM CFG USING NUM_POOLAGENTS 200;
db2stop;
db2start;
D. UPDATE DBM CFG USING NUM_INITAGENTS 0;
db2stop;
db2start;
正解：C
質問 5：
Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?
A. VOLATILE
B. CARDINALITY VOLATILE
C. CURRENT CARDINALITY
D. INDEXSCAN
正解：A
質問 6：
Which action can be performed by the ALTER TABLESPACE statement?
A. Add a container to an SMS table space on a database partition that currently has no containers.
B. Change an SMS table space to a DMS table space on any database partition.
C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
D. Change the size of a container in an SMS table space.
正解：A
質問 7：
What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?
A. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table
B. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Rebind the partitioned table
C. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Reorg the partitioned table
D. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Update statistics on the partitioned table
正解：A
山内** -
C2090-544資格を合格しました。
私の勉強方:問題集に目を通したあと、模擬試験にとりかかりました。全部覚えれるまでに繰り返しました。
短い間、お世話になりました。ありがとうございました。