The information of IBM 000-702 may help you know the certification
Test information:
Number of questions: 61
Time allowed in minutes: 75
Required passing score: 55%
Sample / Assessment test:Test your knowledge prior to taking the test.
The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 UDB Version 8.1 product for the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of the DB2 Universal Database, specifically the new features and functionality related to Version 8.1. This specialist is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration specific to the z/OS operating system.
9.A table encounters heavy insert processing every night. Although the number of inserts remains
unchanged, the time that the insert processing takes increases each night. What should the DBA
examine?
A.DB2 log parameters
B.Free space allocation
C.Buffer pool thresholds
D.Primary space allocation
Correct:B
10.In the PLAN_TABLE for an SQL statement, the ACCESSTYPE is “N” and the METHOD=”2″.
Given these PLAN_TABLE values, which type of access path is DB2 using to retrieve the data?
A.A table space scan with a sort
B.A non-matching index scan with a sort
C.A two-column match in a nested loop join
D.IN-list index access with merge scan join
Correct:D
11.A DBA has detected that incorrect updates to the PAYROLL table in the PERSONNEL database
were made recently. In order to determine what application is making these updates, the DBA
starts an AUDIT trace. Which of the following is necessary to identify all authorization-ids that
update this table in the future?
A.The AUDIT TRACE is sufficient
B.ALTER TABLE PAYROLL AUDIT CHANGES
C.ALTER TABLE PAYROLL AUDIT UPDATES
D.ALTER DATABASE PERSONNEL AUDIT ALL
Correct:B
