PrepAway - Latest Free Exam Questions & Answers

Which command will cause the Design Advisor to make recommendations for a database named SAMPLE, using the inf

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?

PrepAway - Latest Free Exam Questions & Answers

A.
db2advis -d sample -f

B.
db2advis -d sample -i db2advise.in

C.
db2advis -d sample -g

D.
db2advis -d sample -f db2advise.in


Leave a Reply