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

What type of table can be converted into a column-organized table with the db2convert command? A. A range partitioned table B. A materialized query table C. A row-organized user table D. A declared global temporary table

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…

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

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

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

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…

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…

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…

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…