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?
A.
db2advis -d sample -f
B.
db2advis -d sample -i db2advise.in
C.
db2advis -d sample -g
D.
db2advis -d sample -f db2advise.in