Which three types of work can be defined for a Workload Management service class set? (Choose
three.)

A file named db2advise.in contains the text shown below:
–#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname=’HAAS’;
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?

Which two actions can you perform when using Optim Database Administrator?
(Choose two.)

You are running a LOAD utility and have not provided an exception table.
What will happen if duplicates for a unique key get Inserted during the LOAD phase due to
duplicates in the input file?

Table TAB_A is already populated with a large number or rows, and you wish to insert more rows
from a file named dat
a.del. While these row are added, you want users to still have full access to the table in read/Write
mode.
Which command should you use to do this?

Which command will reorg all indexes for a table named TABA?

When are packages automatically rebound?

A file named db2advise.in contains the following text:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named
SAMPLE, using the information found in this file?