IBM 000-612 試験概要:

IBM 000-612 試験シラバストピック:

IBM Certified Database Administrator - DB2 10 for z/OS 認定 000-612 試験問題：

問題 #1

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired.
To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

A. SYSIBM.SYSTABLESPACESTATS
B. SYSIBM.SYSTABLES
C. SYSIBM.SYSSTATS
D. SYSIBM.SYSCOPY

問題 #2

Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

A. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
B. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USINGXMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);
C. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USINGXMLPATTERN '//phone' as sql varchar(20);
D. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);

問題 #3

What is a consideration when specifying DATA CAPTURE CHANGES?

A. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.
B. Can be specified for capturing changes to an XML object.
C. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.
D. You cannot turn on DATA CAPTURE CHANGES if the table space is in
advisoryREORG-pending.

問題 #4

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

A. Turn on a monitortrace.
B. Perform a DISPLAY DATABASE (LOCKS ) command often.
C. Always have a performance trace running.
D. Always have statistics classes 1,3, and 4 and accounting classes 1 and 3 running.

問題 #5

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

A. 4
B. 6
C. 1
D. 5

解説：