Which one of the following statements is FALSE about DB2 Workload Management (WLM)?
A. DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
B. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.
C. DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
D. When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
正解:A
質問 2:
Which one of the following options is TRUE about DB2 pureScale?
A. DB2 pureScale feature does not support range-partitioning tables.
B. DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).
C. A DB2 pureScale installation is only supported on AIX platform.
D. DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).
正解:D
質問 3:
What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
B. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
C. STMM allows DBAs to inspect the current memory allocation by buffer pools.
D. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
正解:D
質問 4:
How does automatic storage work in DB2?
A. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.
B. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.
C. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.
D. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.
正解:C



0 お客様のコメント