Practice questions

Question 1: How do you activate database objects monitoring elements such as object_data_l_reads and object_data_p_reads?

1. UPDATE DBM CFG DFT_MON_TABLE to ON
2. UPDATE DB CFG USING MON_OBJ_METRICS BASE
3. UPDATE MONITOR SWITCHES USING TABLE ON
4. UPDATE DBM CFG USING HEALTH_MON ON

Question 2: Which of the following are column-organized monitoring elements? (Choose two)

1. POOL_COL_L_READS
2. POOL_DATA_L_READS
3. POOL_DATA_P_READS
4. POOL_COL_P_READS
5. POOL_DATA_WRITES

Question 3: Which statement will modify the current explain mode special register so that explain can capture without actually running the SQL statement?

1. SET CURRENT EXPLAIN MODE YES
2. SET CURRENT EXPLAIN MODE NO
3. SET CURRENT EXPLAIN MODE EXPLAIN
4. SET CURRENT EXPLAIN REOPT

Question 4: Which statement is FALSE about the Db2 problem determination tool (db2pd)?

1. The db2pd tool can obtain quick and immediate information...