Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

A. db2pd

B. db2dart

C. db2expln

D. db2advis

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The PAGESIZE database configuration parameter is set to 32K.

B. The AUTO_REORG database configurationparameter is set to NO.

C. The DFT_EXTENT_SZ database configuration parameter is set to 8.

D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit".

BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET Which of the following is TRUE?

A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.

B. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.

C. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might besome uncommitted data in TS1.

D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

A. UPDATE DB CFG USING MON_OBJ_METRICS BASE

B. UPDATE DB CFG USING MON_ACT_METRICS BASE

C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON

D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

A. Authentication

B. Roles and privileges

C. Mandatory access control

D. Discretionary access control

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

A. The page size is too small.

B. The extent size is too small.

C. Low cardinality of the dimension(s) chosen.

D. High cardinality of the dimension(s) chosen.

Given the following: What will be the result of the following SQL statement?

INSERT INTO v3 (col1) values (30);

A. The insert will succeed as it passes validation.

B. The insert will succeed as there is no WITH CHECK OPTION on view V3.

C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

A. db2val

B. db2set

C. db2look

D. db2greg