IBM Information Management DB2 10 Technical Mastery Test v3 v6.0

Page:    1 / 3   
Exam contains 38 questions

Which one of the following sentences does NOT describe a benefit of Temporal Tables?

  • A. 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.
  • B. 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.
  • 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.


Answer : C

What is the DB2 Load utility?

  • 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 is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.
  • C. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.
  • D. The DB2 Load utility can be used to load and create external functions in a DB2 database.


Answer : C

What is a buffer pool in DB2?

  • A. 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.
  • B. A buffer pool is a DB2 component that manages connections to databases.
  • 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 a logical storage grouping composed of one or more containers.


Answer : A

How does automatic storage work in DB2?

  • A. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.
  • 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 is a function of DB2 that allows tables to be backed up automatically on a set schedule.
  • D. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.


Answer : A

Which DB2 licensing type is based on the number of users allowed to access the data server?

  • A. PVU (Processor Value Unit) licensing
  • B. Sub-capacity licensing
  • C. Authorized User (AU) licensing
  • D. Per Server licensing


Answer : C

Which one of the following options is FALSE?

  • A. WLM is not supported in DB2 pureScale environments.
  • B. HADR with multiple standbys supports reads on all standby databases.
  • C. Implementation of a row and column access control policy is transparent to applications accessing the database.
  • D. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into DB2 tables.


Answer : A

What is a DB2 instance?

  • A. A DB2 instance is just another name for DB2 Database.
  • B. A DB2 instance is a copy of a database that can be accessed standalone from the database server.
  • C. A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.
  • D. DB2 does not use instances. It requires only databases to operate.


Answer : C

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 uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
  • C. DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
  • D. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.


Answer : C

What is a table space in DB2?

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


Answer : D

The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?

  • A. Temporary Tables Compression
  • B. Declared Global Temporary Tables Compression
  • C. Adaptive Compression
  • D. Classic Row Compression


Answer : C

The following are true about the Configuration Advisor, EXCEPT:

  • A. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
  • B. It creates database objects such as indexes and MQTs to improve performance.
  • C. By default, the Configuration Advisor is automatically executed when you create a new database.
  • D. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.


Answer : B

Which one of the following options is NOT a new feature introduced in DB2 10?

  • A. Temporal Tables
  • B. Table Partitioning
  • C. Multi-Temperature Data Management
  • D. INGEST utility


Answer : B

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?

  • A. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
  • B. Table data is protected against direct access to the table. Access using views is unrestricted.
  • C. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.
  • D. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.


Answer : D

DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the
CORRECT statement about HADR.

  • A. HADR protects against data loss by saving data changes from a source database into a local recovery log file.
  • B. HADR protects against data loss by replicating data changes from a backup database file to a standby database.
  • C. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.
  • D. HADR feature is only available for DB2 Advanced Enterprise Edition.


Answer : C

What does the table partitioning feature in DB2 allow you to do?

  • A. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.
  • B. 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.
  • 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 partition the table data based on the hash values of the primary key.


Answer : B

Page:    1 / 3   
Exam contains 38 questions

Talk to us!


Have any questions or issues ? Please dont hesitate to contact us

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy