IBM DB2 000-702

aoluo

VUE/Prometric Code: 000-702

Exam: DB2 udb v8.1 for z/os database Administration

Ver:V3.27
Q&A:122 Q&As

업그레이트:2010-05-15



1.Running accounting classes 1 and 2 for performance analysis is recommended for which of the
following reasons?
A.DB2 time can be separated from application time.
B.A detailed view of the access path is reported.
C.Detail is reported on the I/O wait time.
D.Detail is reported down to the package and DBRM level.
Correct:A

2.The following query can be used to check the catalog for consistency: SELECT DBNAME, NAME
FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT * FROM
SYSIBM.SYSDATABASE DB WHERE DB. NAME = TS.DBNAME); Which specific condition is this
query testing?
A.It validates all of the columns in SYSTABLESPACE.
B.It finds all of the table spaces in SYSDATABASE that do not have any rows in SYSTABLESPACE.
C.It finds all of the databases in SYSDATABASE that do not have corresponding rows in
SYSTABLESPACE.
D.It finds all of the databases in SYSTABLESPACE that do not have corresponding rows in
SYSDATABASE.
Correct: D

3.Periodic incremental image copies are taken on a regular basis. Which of the following would
best help reduce the recovery time?
A.Purge old log records
B.Purge old incremental copies
C.Take more frequent incremental image copies
D.Merge the incremental copies with the last full copy
Correct: D

4.A newly created partitioned table space has been created with the DEFINE NO attribute. Which
of the following is the best way to ensure partition parallelism when initially loading the table?
A.No special considerations needed. Partition parallelism will always be enforced.
B.For a partitioned table space with DEFINE NO, the initial load cannot use partition parallelism.
C.Run a load job without specifying the PART n clause. DB2 will automatically use partition parallelism
when possible.
D.Run a load job with an empty data file for the first partition. Then run the load jobs for each partition in
parallel.
Correct: D

5.To minimize storage usage in a stored procedure address space, which of the following
parameters could be altered?
A.APPLENV
B.CTHREAD
C.NUMTCB
D.STORTIME
Correct:C

steven: sales@killtest.kr    Katherine: sales1@killtest.kr

[ Last edited by  aoluo at 2010-6-1 09:44 ]