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

質問 1：
Which statement about the db2pd tool is true?
A. It collects information from the snapshot monitor and a predefined set of event monitors.
B. It ensures that information is not retrieved on changing data.
C. It collects information from the log buffer and active log files.
D. It may retrieve data that is not completely accurate.
正解：D

質問 2：
What type of Label-Based Access Control (LBAC) security label component is used to define a scale in which the first element listed represents the highest level of trust a person can have and the last element listed represents the lowest level of trust a person can have?
A. Array
B. Set
C. Range
D. Tree
正解：A

質問 3：
A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?
A. NLJOIN
B. HSJOIN
C. TBSCAN
D. IXSCAN
正解：D

質問 4：
Which tool should be used to collect data during a potential hang without stopping the database manager?
A. db2cklog
B. db2dart
C. db2ls
D. db2fodc
正解：D

質問 5：
Which statement regarding snapshot administrative views and snapshot monitor table functions is true?
A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.
B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.
C. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.
D. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.
正解：C

質問 6：
Which statement about the ADMIN_MOVE_TABLE procedure is true?
A. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.
B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.
C. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.
D. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
正解：D

質問 7：
Which authority is required to revoke SECADM authority?
A. SYSADM
B. SQLADM
C. SECADM
D. DBADM
正解：C

質問 8：
If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?
A. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.
B. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.
D. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
正解：D

質問 9：
Which statement regarding compression for temporary tables is true?
A. Temporary tables can only be compressed using adaptive compression.
B. Temporary tables can only be compressed using classic row compression.
C. Compression for temporary tables can be dynamically enabled and disabled.
D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.
正解：B