716 お客様のコメント
質問 1：
Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)
A. REORG
B. LOAD
C. TRUNCATE
D. IMPORT
正解：A,B
質問 2：
A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
A. Executes the first SOL statement in the workload file 100 times.
B. Executes both SQL statements in the workload file 100 times.
C. Executes up to 100 combinations of optimizations for both SQL statements in the workload file
D. Executes an index analysis for the first SQL statement in the workload file 100 times.
正解：B
質問 3：
Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?
A. ALTER INDEXtablxl PCTFREE 40
B. ALTER INDEXtablxl CLUSTER
C. ALTER INDEXtablxl ADD COLUMN (col_2)
D. ALTER INDEXtablxl COMPRESS YES
正解：D
質問 4：
Which command is used to configure the administrative task scheduler to execute tasks?
A. db2set D B 2_EXE C_S C H E D U LE_E NAB LE=YE S
B. db2set D B 2_AT S_E NAB LE=YE S
C. db2setDB2 SCHEDULE ENABLE=YES
D. db2set D B 2_EXE C_AT S_E NAB LE=YE S
正解：B
質問 5：
Which three table features can be used concurrently in the same table? (Choose three.)
A. partitioned tables
B. MDC tables
C. range-clustered tables
D. local indexes
E. primary key index
正解：A,B,D
質問 6：
Click the Exhibit button
Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?
A. UPDATE DBM CFG USING NOTIFYLEVEL4
B. UPDATE DBM CFG USING DI AG LEVEL 4
C. UPDATE DBM CFG USING NOTIFYLEVEL 4; STOP DATABASE MANAGER; START DATABASE MANAGER;
D. UPDATE DBM CFG USING DIAGLEVEL 3; UPDATE DBM CFG USING NOTIFYLEVEL 4;
正解：A
質問 7：
Click the Exhibit button.
IBM 000-541: Practice Exam
Referring to the exhibit, which security mechanism would be used to authenticate a remote user running a db2trc command?
A. SERVER ENCRYPT authentication
B. GSS-APIplugin "db2trc"
C. CLIENT_ENCRYPT authentication
D. CLIENT authentication
正解：A
質問 8：
For which two purposes would you run the db2look tool? (Choose two.)
A. To extract the statistics information for a series of objects in a database and generate UPDATE statements to manually update the statistics
B. To extract the data from several tables in a database, ready to be imported or loaded.
C. To extract the data offline from a given page in a table and store the data in a delimited file.
D. To extract the definition of objects in a database and generate DDL statements to recreate them.
正解：A,D
Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)
A. REORG
B. LOAD
C. TRUNCATE
D. IMPORT
正解：A,B
質問 2：
A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
A. Executes the first SOL statement in the workload file 100 times.
B. Executes both SQL statements in the workload file 100 times.
C. Executes up to 100 combinations of optimizations for both SQL statements in the workload file
D. Executes an index analysis for the first SQL statement in the workload file 100 times.
正解：B
質問 3：
Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?
A. ALTER INDEXtablxl PCTFREE 40
B. ALTER INDEXtablxl CLUSTER
C. ALTER INDEXtablxl ADD COLUMN (col_2)
D. ALTER INDEXtablxl COMPRESS YES
正解：D
質問 4：
Which command is used to configure the administrative task scheduler to execute tasks?
A. db2set D B 2_EXE C_S C H E D U LE_E NAB LE=YE S
B. db2set D B 2_AT S_E NAB LE=YE S
C. db2setDB2 SCHEDULE ENABLE=YES
D. db2set D B 2_EXE C_AT S_E NAB LE=YE S
正解：B
質問 5：
Which three table features can be used concurrently in the same table? (Choose three.)
A. partitioned tables
B. MDC tables
C. range-clustered tables
D. local indexes
E. primary key index
正解：A,B,D
質問 6：
Click the Exhibit button
Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?
A. UPDATE DBM CFG USING NOTIFYLEVEL4
B. UPDATE DBM CFG USING DI AG LEVEL 4
C. UPDATE DBM CFG USING NOTIFYLEVEL 4; STOP DATABASE MANAGER; START DATABASE MANAGER;
D. UPDATE DBM CFG USING DIAGLEVEL 3; UPDATE DBM CFG USING NOTIFYLEVEL 4;
正解：A
質問 7：
Click the Exhibit button.
IBM 000-541: Practice Exam
Referring to the exhibit, which security mechanism would be used to authenticate a remote user running a db2trc command?
A. SERVER ENCRYPT authentication
B. GSS-APIplugin "db2trc"
C. CLIENT_ENCRYPT authentication
D. CLIENT authentication
正解：A
質問 8：
For which two purposes would you run the db2look tool? (Choose two.)
A. To extract the statistics information for a series of objects in a database and generate UPDATE statements to manually update the statistics
B. To extract the data from several tables in a database, ready to be imported or loaded.
C. To extract the data offline from a given page in a table and store the data in a delimited file.
D. To extract the definition of objects in a database and generate DDL statements to recreate them.
正解：A,D
Sakata -
C2090-541試験対策はこの問題集ひとつで充分足りるんじゃないかと思ってます。Pass4Testさんはいつも信用しております。