IBM C2090-600 IBM DB2 11.1 DBA for LUW Exam Practice Test

Compression must be explicitly enabled for BLU MPP tables

Compression requires decompression to evaluate partition joins

Unique compression dictionaries are generated for each partition

Each table has a single compression dictionary that getsreplicated across all partitions

NOT ENFORCED unique constraints can not be defined on primary key columns

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

When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

SELECT tbsp_name, tbsp_utilization_percent

FROM TABLE(sysproc.mon_tbsp_utilization()) AS t

WHERE tbsp_utilization_percent > 95

AND tbsp_auto_resize_enabled = 1;

SELECT tbsp_name, tbsp_utilization_percent

FROM syscat.mon_tbsp_utilization

WHERE tbsp_utilization_percent > 95

AND tbsp_auto_resize_enabled = 0;

SELECT tbsp_name, tbsp_utilization_percent

FROM syscat.mon_tbsp_utilization

WHERE tbsp_utilization_percent > 95

AND tbsp_auto_resize_enabled = 1;

SELECT tbsp_name, tbsp_utilization_percent

FROM sysibmadm.mon_tbsp_utilization

WHERE tbsp_utilization_percent > 95

AND tbsp_auto_resize_enabled = 0;

The page size is too small.

The extent size is too small.

Low cardinality of the dimension(s) chosen.

High cardinality of the dimension(s) chosen.

UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

CONNECT TO sample;

UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;

CONNECT RESET;

ATTACH TO db2inst1;

UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;

DETACH;

db2val

db2set

db2look

db2greg

When the registry variableDB2_AUTORECLAIMSPACE=YES

After termination all the back-end processes using TERMINATE command

After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON

When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

LOAD

INGEST

IMPORT

TRANSPORT

To prunethe contents of a staging table.

To prune the contents of a synopsis table.

To prune the contents of a materialized query table (MQT).

To prune the contents of a declared global temporary table.