IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup. B. The DB2 Load utility can be used to load and create external functions in a DB2
database. C. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with. D. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

A. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule. B. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data. C. Automatic storage allows automatic allocation of free space in memory for optimizing query execution. D. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.

A. A table space is a DB2 component that manages access to databases. B. A table space is a space reserved for catalog tables and base table data. C. A table space 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. D. A table space is a logical storage grouping that can be composed of one or more containers.

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. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class. D. When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.