A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
A. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.
B. Perform RUNSTATS on the ORA1 nickname at the federated server.
C. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.
D. Perform the equivalent of RUNSTATS on ORA1 in Oracle.
正解:A
質問 2:
If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?
A. DB2_EXTENDED_IO_FEATURES
B. DB2_APM_PERFORMANCE
C. DB2_PARALLEL_IO
D. DB2_RESOURCE_POLICY
正解:C
質問 3:
At which two levels can events be audited? (Choose two.)
A. Instance level
B. Server level
C. Database level
D. Operating System level
E. Node level
正解:A,C
質問 4:
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
A. DB2_SET_MAX_CONTAINER_SIZE
B. DB2_LIMIT_AS_CONTAINER_BLOCKS
C. DB2_ALLOCATION_SIZE
D. DB2_TRUNCATE_AS_STORAGE
正解:A
質問 5:
Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?
A. User-defined function calls will be disabled.
B. In a partitioned environment, infinite communications will be enabled between partitions.
C. Non-fenced routines can be invoked, however automatic database maintenance will be disabled.
D. In a partitioned environment, communications will not be buffered.
正解:C
質問 6:
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A. Workload Manager
B. Design Advisor
C. Configuration Advisor
D. Partition Assistant
正解:B
質問 7:
Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?
A. VOLATILE
B. CARDINALITY VOLATILE
C. CURRENT CARDINALITY
D. INDEXSCAN
正解:A
質問 8:
Which type of table queue is used to pass data between database partitions when rows are being fetched?
A. listener table queue
B. synchronous table queue
C. asynchronous table queue
D. non-merging table queue
正解:C
質問 9:
Which statement is true about clustering indexes in a partitioned database?
A. The partitioning key column(s) should be added to the clustering index with the INCLUDE option.
B. The clustering index column(s) should be prefixed by the partitioning key column(s).
C. The clustering index column(s) should be suffixed by the partitioning key column(s).
D. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.
正解:B