Which constraints are used to tell the DB2 Optimizer to consider business rules that are not
enforced by the database manager?

Given the following database design:

A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM
dimension table and the SALES fact table. Which action should be performed to improve query
performance?

Which procedure is used to Explain an SQL statement using information obtained from the
package cache or the package cache event monitor?

Which statement about the initiation of parallel I/O is correct?

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE : ADM5502W The escalation of “28581” locks on table “TEST.TABLE1” to lock intent
“X” was successful. Which two database configuration parameter settings should be checked?
(Choose two.)

Consider the following statement:

Which indexes should be created for optimal query performance?

What will occur when a database administrator adds a new automatic storage path to an existing
storage group?

Which monitoring tool can be used to obtain stripe set information for database managed storage
table spaces?

Which statement about value compression is correct?

Which statement about compression dictionaries is FALSE?