819 お客様のコメント
質問 1：
What is the minimum privilege required to run the audit stored procedures and table functions (AUDIT_LIST_LOGS and AUDIT_ARCHIVE)?
A. DATAACCESS privilege on the audit stored procedures and table functions.
B. ACCESSCTR privilege on the audit stored procedures and table functions.
C. EXECUTE privilege on the audit stored procedures and table functions.
D. SECADM authority on database.
正解：C
質問 2：
Click on the Exhibit button
Given the following DDL statements:
If COL2 contains XML documents similar to the one shown in the scenario, what is the end result of the CREATE INDEX statement?
A. An error will be returned because it is not possible to include more than one column as part of the CREATE INDEX statement when one of the columns is of type XML.
B. An error will be returned because it is not possible to create an index for an XML column like COL2.
C. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX will automatically be created within the first index partition listed in the create table statement.
D. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table space as the related data.
正解：A
質問 3：
The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?
A. RECOVER DB sample TO END OF BACKUP;
ROLLFORWARD DB sample AND COMPLETE;
B. RECOVER DB sample TO END OF BACKUP;
C. RESTORE DB sample;
ROLLFORWARD DB sample TO END OF BACKUP AND COMPLETE;
D. RESTORE DB sample TO END OF BACKUP AND STOP;
正解：C
質問 4：
Which command/statement is used to implement Currently Committed (CC) semantics behavior on an application-by-application basis?
A. UPDATE DB CFG FOR <db_name> USING CUR_COMMIT AVAILABLE
B. UPDATE DBM CFG USING EVALUNCOMMITTED NO
C. SET CURRENT ISOLATION CC
D. db2set DB2_USE_CURRENTLY_COMMITTED=YES
正解：A
質問 5：
Table TAB_A and index TABA_IDX were created by executing these SQL statements:
If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?
A. The index will remain compressed until it is REORGed.
B. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.
C. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.
D. The index will be uncompressed immediately.
正解：A
質問 6：
Which DB2 9.7 database authority can be granted to the group PUBLIC?
A. ACCESSCTRL
B. SQLADM
C. DATAACCESS
D. SECADM
正解：B
What is the minimum privilege required to run the audit stored procedures and table functions (AUDIT_LIST_LOGS and AUDIT_ARCHIVE)?
A. DATAACCESS privilege on the audit stored procedures and table functions.
B. ACCESSCTR privilege on the audit stored procedures and table functions.
C. EXECUTE privilege on the audit stored procedures and table functions.
D. SECADM authority on database.
正解：C
質問 2：
Click on the Exhibit button
Given the following DDL statements:
If COL2 contains XML documents similar to the one shown in the scenario, what is the end result of the CREATE INDEX statement?
A. An error will be returned because it is not possible to include more than one column as part of the CREATE INDEX statement when one of the columns is of type XML.
B. An error will be returned because it is not possible to create an index for an XML column like COL2.
C. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX will automatically be created within the first index partition listed in the create table statement.
D. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table space as the related data.
正解：A
質問 3：
The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?
A. RECOVER DB sample TO END OF BACKUP;
ROLLFORWARD DB sample AND COMPLETE;
B. RECOVER DB sample TO END OF BACKUP;
C. RESTORE DB sample;
ROLLFORWARD DB sample TO END OF BACKUP AND COMPLETE;
D. RESTORE DB sample TO END OF BACKUP AND STOP;
正解：C
質問 4：
Which command/statement is used to implement Currently Committed (CC) semantics behavior on an application-by-application basis?
A. UPDATE DB CFG FOR <db_name> USING CUR_COMMIT AVAILABLE
B. UPDATE DBM CFG USING EVALUNCOMMITTED NO
C. SET CURRENT ISOLATION CC
D. db2set DB2_USE_CURRENTLY_COMMITTED=YES
正解：A
質問 5：
Table TAB_A and index TABA_IDX were created by executing these SQL statements:
If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?
A. The index will remain compressed until it is REORGed.
B. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.
C. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.
D. The index will be uncompressed immediately.
正解：A
質問 6：
Which DB2 9.7 database authority can be granted to the group PUBLIC?
A. ACCESSCTRL
B. SQLADM
C. DATAACCESS
D. SECADM
正解：B
庄司** -
完璧です。また買いに来ます。
Pass4Testさん、試験に合格できました。本当に助けになりました。