Which of the following are valid Explain operators? (Choose two.)
A. XSCAN
B. COLSCAN
C. CTQ
D. SELECT
E. IXSCAN
正解:A,E
質問 2:
Which of the following statements is TRUE?
A. REORGCHK uses only current table and index statistics.
B. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
C. REORGCHK can only be used for user tables, not for system tables.
D. REORGCHK automatically run stables reorganization.
正解:A
質問 3:
The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)
A. You can remove the primary database from the target list of a standby although the standby is connected to the primary.
B. You can change the principal standby of the primary without first stopping HADR on the primary.
C. The target list can contain IP addresses that are either 1Pv4, or 1Pv6, or a combination of the two.
D. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.
E. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
正解:B,D
質問 4:
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
A. Using or altering the default service classes and workloads
B. Granting, altering, or revoking workload privileges
C. Creating, activating, stopping or dropping workload management event monitors
D. Creating service classes, service subclasses, and workloads
E. Creating, using, or altering thresholds
正解:B,D
質問 5:
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
A. To prune the contents of a materialized query table (MQT).
B. To prune the contents of a synopsis table.
C. To prune the contents of a staging table.
D. To prune the contents of a declared global temporary table.
正解:C
質問 6:
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?
A. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
B. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
C. CONNECT TO sample; UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;
D. ATTACH TO db2instl;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;
正解:C
堀田** -
Pass4Testさんのアプリバージョンの模擬試験を繰り返し行うことで、模擬試験に慣れることができる