IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 Sample Questions:
1. Which one of the following statements is FALSE about DB2 Workload Management
(WLM)?
A) When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
B) DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.
C) DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
D) DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
2. Where is data stored in a typical DB2 pureScale environment?
A) Data is split among both, members and a shared storage.
B) In a shared storage accessible by all members.
C) All members hold a local data partition of the database.
D) Data is permanently stored in the cluster caching facility.
3. Which one of the following options is INCORRECT about DB2 pureScale?
A) DB2 10 pureScale is able to leverage DB2's Workload Manager.
B) DB2 10 pureScale introduced support for range-partitioned tables. Attach/detach operations are limited to the first and last partitions only.
C) DB2 10 pureScale introduced support for split mirror technology as a backup method.
D) DB2 10 pureScale introduced support for partitioned indexes and partition reorgs.
4. Each DB2 member in a DB2 pureScale environment has an associated database log.
Where is this log stored?
A) Shared storage.
B) Tie-breaker disk.
C) Locally on each member.
D) Cluster caching facility.
5. A database administrator retrieved the following status from the DB2 members in a DB2 pureScale environment:
Which of the following options will start ONLY the member hosted in NODE102?
A) db2cluster -node node102 -exit - maintenance
B) db2start NODE102
C) db2start member 1
D) db2start member on NODE102
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: C |
768 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
