How is the Query Workload Tuner license installed and enabled?

If the DB2_WORKLOAD registry variable has not been set which database manager configuration
parameter must be modified, before a query that accesses a column-organized table can be
executed?

If the following commands are executed successfully:

Which SQL statement will fail?

Which command, when executed, will enable workload management for column-organized table
workloads?

If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the
DFT_DEGREE database configuration parameter, by default?

By default, the Optim Workload Table Organization Advisor will recommend converting roworganized tables to column-organized tables if it determines that the change will improve query
performance, as a whole, by how much?

What formula can be used to determine the average number of column-organized pages found in
each read request?

Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner
that generate EXPLAIN information when creating the query workload?

Which type of compression is typically used with column-organized tables?

Which statement about column-organized tables is true?