C2090-311 Online Practice Questions and Answers

By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

A. 15 percent

B. 20 percent

C. 25 percent

D. 30 percent

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.

An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.

If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:

RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY

Which command will create a statistics profile on the EMPLOYEE table?

A. RUNSTATS ON TABLE employee USE PROFILE

B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1

C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL

D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE

When does space reclamation for a column-organized table normally occur?

A. Whenever an individual row is deleted.

B. Whenever an individual row is updated.

C. After all rows in an extent have been updated.

D. After all rows in an extent where updates took place have been deleted.

If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?

A. Multi-tenancy

B. Workload consolidation

C. Independent tuning member

D. Broadcasting STMM tuning decisions to all members

E. Single INSTANCE_MEMORY instance configuration memory setting

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 can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

A. When crash recovery is occurring on the standby cluster.

B. When all the log streams are in peer or assisted remote catchup state.

C. When the primary database is not connected to the standby database.

D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.

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.

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