Oracle
1Z0-067 · Question #30
1Z0-067 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #30. 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, the database 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
- ASQL Performance Analyzer
- BSQL Access Advisor
- CSQL Tuning Advisor
- DAutomatic Workload Repository (AWR) report
- EAutomatic Database Diagnostic Monitor (ADDM)
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 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.