000-702 考试题库

免费下载000-702认证考题Demo

下载 000-702 Pdf 认证考试题库
　
　
Exam : IBM 000-702
Title : DB2 UDB V8.1 For Z/OS DataBase Administration


1. 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.
Answer: D

2. 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.
Answer: 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
Answer: D

4. 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.
Answer: A

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
Answer: C

选择 QuickPass 000-702 题库

000-702 考试是 IBM 公司的 DB2 认证考试官方代号，QuickPass 的 000-702 权威考试题库软件是 IBM 认证厂商的授权产品，QuickPass 绝对保证第一次参加 000-702 考试的考生即可顺利通过，否则承诺全额退款！

DB2 认证作为全球IT领域专家 IBM 热门认证之一，是许多大中IT企业选择人才标准的必备条件。 如果你正在准备 000-702 考试，为 IBM DB2认证做最后冲刺，又苦于没有绝对权威的考试真题模拟， QuickPass 希望能助你成功。

Quickpass 000-702 Exam Features