최신 DB2 000-612 무료샘플문제:

1. Which of the following tasks cannot be done via a single ALTER TABLE statement?

A) Add a new partition to the table space.
B) Change the DATA CAPTURE attribute of the table.
C) Change a table check constraint on the table.
D) Change the VALIDPROC attribute of the table.

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 '//name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);
B) 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);
C) 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);
D) 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);

3. For which table type could you specify ALTERTABLE tb1 DATA CAPTURE CHANGES?

A) Catalog tables
B) Auxiliary tables
C) Directory tables
D) Declared global temporary tables

4. Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

A) DSN1CHKR
B) CHECKLOB
C) DSN1COPY
D) CHECK INDEX

5. During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

A) RBA
B) LRSN
C) ROWID
D) SYSPITRT

질문과 대답: