How is the Query Workload Tuner license installed and enabled?

A. With Data Studio, using the license activation kit.

B. By executing the db2licm command after data server installation.

C. With the Optim Performance Manager Server, using the license activation kit.

D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.

What formula can be used to determine the average number of column-organized pages found in each read request?

A. POOL_COL_READS/ POOL COL READ REQS

B. POOL_COL_P_READS/ POOL COL P READ REQS

C. POOL_ASYNC_COL_READS/ POOL ASYNC COL READ REQS

D. POOL ASYNC COL P READS/POOL ASYNC COL P READ REQS

Which statement about column-organized tables is true?

A. Databases with column-organized tables can be federated.

B. Schemas that include column-organized tables can be transported.

C. Sort memory can be automatically tuned in environments containing column-organized tables.

D. Queries that use the Currently Committed semantics can be used with column-organized tables.

What is a DB2 Advanced Copy Services (ACS) script used for?

A. To install and configure DB2 Advanced Copy Services.

B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.

C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.

D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.

Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

A. EHL is enabled by default in DB2 10.5 pureScale environments.

B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.

C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.

D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.

In which type of database are column-organized tables supported?

A. Partitioned databases.

B. DB2 pureScale databases.

C. Databases whose code set is Unicode.

D. Databases whose code set is Non-Unicode.

What are the correct steps to capture EXPLAIN information for column-organized tables?

A. 1. Issue the query against column-organized tables

2. Execute the db2exfmt command

B. 1. Execute the command CURRENT EXPLAIN MODE YES

2.

Issue the query against column-organized tables

3.

Execute the db2exfmt command

C. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2.

Issue the query against column-organized tables

3.

Execute the db2exfmt command

D. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2.

Execute the command CURRENT EXPLAIN MODE YES

3.

Issue the query against column-organized tables

4.

Execute the db2exfmt command

Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?

A. MON_GET_TABLE()

B. MON_GET_TABLESPACE()

C. MON_GET_UNIT_OF_WORK()

D. MON_GET_TABLE_USAGE_LIST()

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?

A. A warning is returned and no statistics are collected.

B. An error is returned and the table is placed in "load pending" state.

C. A statistics profile is automatically generated before the load is allowed to continue.

D. The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.

Which statement regarding NOT ENFORCED unique constraints is true?

A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.

B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.

C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.

D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.