質問 1：
Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?
A. db2trace
B. db2pd
C. db2diag
D. db2fmtdiag
正解：C
質問 2：
Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?
A. ALTER TABLE mytab CHECK (COL IS VALIDATED)
B. ALTER TABLE mytab ALLOW READ ACCESS;
SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;
C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED
D. SET INTEGRITY FOR mytab IMMEDIATE CHECKED
正解：D
質問 3：
What can be used to provide input to the Design Advisor?
A. The database manager configuration file.
B. An XML file.
C. The database configuration file.
D. A query workload file.
正解：D
質問 4：
How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?
A. By using the DB2 problem determination tool.
B. By using the change history event monitor.
C. By examining the DB2 administration notification log file.
D. By examining the contents of the system catalog.
正解：B
質問 5：
An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?
A. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.
B. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.
C. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
正解：D
質問 6：
Which table space is NOT created by default when the CREATE DATABASE command is executed?
A. SYSTOOLSSPACE
B. USERSPACE1
C. SYSCATSPACE
D. TEMPSPACE1
正解：A
Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?
A. db2trace
B. db2pd
C. db2diag
D. db2fmtdiag
正解：C
質問 2：
Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?
A. ALTER TABLE mytab CHECK (COL IS VALIDATED)
B. ALTER TABLE mytab ALLOW READ ACCESS;
SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;
C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED
D. SET INTEGRITY FOR mytab IMMEDIATE CHECKED
正解：D
質問 3：
What can be used to provide input to the Design Advisor?
A. The database manager configuration file.
B. An XML file.
C. The database configuration file.
D. A query workload file.
正解：D
質問 4：
How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?
A. By using the DB2 problem determination tool.
B. By using the change history event monitor.
C. By examining the DB2 administration notification log file.
D. By examining the contents of the system catalog.
正解：B
質問 5：
An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?
A. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.
B. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.
C. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
正解：D
質問 6：
Which table space is NOT created by default when the CREATE DATABASE command is executed?
A. SYSTOOLSSPACE
B. USERSPACE1
C. SYSCATSPACE
D. TEMPSPACE1
正解：A
0 お客様のコメント