最新なIBM A2090-541問題集（104題）、真実試験の問題を全部にカバー！

質問 1：
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

質問 2：
Which statement is correct when describing the AUTOCONFIGURE command?
A. It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for all databases within an instance, with the option of applying these values.
B. It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for a single database, with the option of applying these values.
C. It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for all databases within an instance, with the option of applying these values.
D. It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for a single database, with the option of applying these values.
正解：D

質問 3：
Which DB2 tool is a Java-based, generic XML parser which produces readable text output from the data generated by an event monitor?
A. db2evmonfrnt
B. db2eventfmt
C. db2xmlparser
D. db2evmonparser
正解：A

質問 4：
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)
A. db2xprt
B. db2diag
C. db2dart
D. db2exfmt
正解：B,C

質問 5：
Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?
A. db2top
B. db2dart
C. db2pm
D. db2fodc
正解：A

質問 6：
How does the DB2 Server identify the list of GSS-API plug-ins it supports?
A. by using the SRVSUPP_GSSPLUGIN_LIST database manager configuration parameter
B. by using the SRVCON_GSSPLUGIN_LIST registry variable
C. by using the SRVCON_GSSPLUGIN_LIST database manager configuration parameter
D. by using the SRVSUPP_GSSPLUGIN_LIST registry variable
正解：C

質問 7：
Which two tools can create a compression dictionary? (Choose two.)
A. INSPECT
B. LOAD
C. db2dart
D. RESTORE
正解：A,B

質問 8：
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

質問 9：
The SELF_TUNING_MEM database configuration (db cfg) parameter is set to ON.
Which three statements will cause the memory tuner to actively tune memory within the database? (Choose three.)
A. At least one buffer pool has its size set to AUTOMATIC.
B. The SORTHEAP db cfg parameter is set to AUTOMATI
C. MAXLOCKS is set to AUTOMATIC.
D. One dbcfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to AUTOMATIC.
E. Any two of LOCKLIST, SHEAPTHRES_SHR,PCKCACHESZ are set to AUTOMATIC.
正解：B,D,E