IBM Information Management DB2 10 Technical Mastery Test v3 Sample Questions:
1. What is a buffer pool in DB2?
A) A buffer pool is a DB2 component that manages connections to databases.
B) A buffer pool is a logical storage grouping composed of one or more containers.
C) A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
D) A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
2. Which one of the following options is TRUE about High Availability and Disaster Recovery (HADR) feature?
A) HADR allows up to four HADR standby databases.
B) HADR allows up to two HADR standby databases.
C) HADR allows up to five HADR standby databases.
D) HADR allows up to three HADR standby databases.
3. Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A) Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
B) Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
C) Temporal tables allow better data management by letting the application control data integrity and uniqueness.
D) Temporal tables provide a quick and easy way to track and record data changes in the table.
4. 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) When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
D) DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: A |
We're so confident of our products that we provide no hassle product exchange.


By Bert

