최신IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018무료샘플문제

A. DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.

B. DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.

C. When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.

D. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.

A. Table partitioning allows you to partition the table data based on the hash values of the primary key.

B. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

C. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

D. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

A. Compression allows you to cache more data in the buffer pools using the same amount of space.

B. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.

C. Compression allows you to reduce CPU workload because there is less data to process.

D. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

A. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

B. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

C. Java Generic Table Functions can be implemented in any programming language.

D. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.