IBM 000-612 問題集

質問 1：
What is the purpose of the following query? SELECT DBNAME, NAME FROM
SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,
TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERETP.DBNAME = TS.DBNAME
AND TP.TSNAME = TS.NAME);
A. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
B. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
C. It identifies which table spaces have missing relatedrows in SYSIBM.SYSTABLEPART.
D. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
正解：C

質問 2：
When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?
A. DSN1LOGP
B. DSN1PRNT
C. DSN1COMP
D. DIAGNOSE
正解：C

質問 3：
Which authoritylevel allows a user to run utilities that change the data in an application database?
A. DBMAINT
B. SYSOPR
C. DBCTRL
D. INSTALL SYSOPR
正解：C

質問 4：
You have to design a table and application layout, in which automatic number generationis used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?
A. Identity cannot deliver this functionality, but Sequence can.
B. Identity can deliver this functionality, but Sequence cannot.
C. Identity and Sequence can both deliver this functionality.
D. Neither Identity nor Sequence can deliver this functionality.
正解：A

質問 5：
Which minimum system privilege allows you to create a trusted context?
A. DBADM
B. SECADM
C. ACCESSCTRL
D. SYSCTRL
正解：B

質問 6：
In order to retain an access path across a rebind which of the following commands could be used?
A. REBIND PACKAGE(PK1) REOPT(ONCE)
B. BIND PLAN
C. REBIND PACKAGE (PK1) PLANMGMT(BASIC)
D. BIND PACKAGE (PK1) EXPLAIN(YES)
正解：C

質問 7：
Which ALTER TABLE statement will generate a new table space version?
A. ALTER TABLE ... ADD COLUMN COL2 ...
B. Altering an already existing VARCHAR column on the table to shorten its maximum length.
C. ALTER TABLE ... ADD PARTITION ...
D. ALTER TABLE ... DATA CAPTURE CHANGES ...
正解：A

質問 8：
Which of the following does NOT make a view a read-only view?
A. The outer fullselect contains a GROUP BY clause.
B. The first SELECT clause specifies the keyword DISTINCT.
C. The only table referenced is asystem maintained temporal table and a period- specification is specified.
D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.
正解：D

質問 9：
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 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);
B. 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);
C. 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);
D. 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);
正解：A