For which two purposes would you run the db2look tool? (Choose two.)

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?

If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?

When using Optim Database Administrator to generate a change script, users
are given which two EXPORT utility output formats to preserve their data when
they drop a table then create a new table with the data? (Choose two.)

Visual Explain uses which explain facility to capture information?

Which method may be used to collect deadlock information in DB2 97?

Which three authorizations allow you to execute db2pd? (Choose three.)

What are three implementations for DB2 Workload Management? (Choose three.)

What are three default service classes used by Work Load Management? (Choose
three.)

Which DB2 tool is a Java-based, generic XML parser which produces readable
text output from the data generated by an event monitor?