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?

Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with
the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF
format. Which command(s) can be used to do this?

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the
statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE

Which two operations allow you to control the creation of the compression dictionary using the
KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)