C2090-311 Online Practice Questions and Answers

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.

If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?

A. INTRA_PARALLEL

B. QUERY_HEAP_SZ

C. MAXIMUM DEGREE

D. SHEAPTHRES SHR

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 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.

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()

When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?

A. 32 KB

B. 64 KB

C. 1MB

D. 2 MB

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

A. Row compression

B. Index compression

C. Backup compression

D. Temporary table compression