Oracle
1Z0-062 · Question #243
1Z0-062 Question #243: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #243. The question stem and answer options stay visible for context.
Question
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, thedatabase is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
Options
- AAutomatic Database Diagnostic Monitor (ADDM)
- BSQL Tuning Advisor
- CSQL Access Advisor
- DSQL Performance Analyzer
- EAutomatic Workload Repository (AWR) report
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.