Oracle
1Z0-064 · Question #61
Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the…
The correct answer is D. Create an STS for the queries cached in the library cache and submit it as an input to SQL. See the full explanation below for the reasoning.
Question
Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the library cache to receive recommendations about the usage of indexes and materialized views. What should you do to achieve this? (Choose the best answer.)
Options
- ACreate an STS for the queries cached in the library cache and submit it as an input to SQL
- BCreate an STS for the queries cached in the library cache and submit it as an input to SQL
- CCapture the workload in an STS and submit to SQL Tuning Advisor for recommendations.
- DCreate an STS for the queries cached in the library cache and submit it as an input to SQL
How the community answered
(26 responses)- A4% (1)
- B15% (4)
- C4% (1)
- D77% (20)
Community Discussion
No community discussion yet for this question.