Oracle
1Z0-034 · Question #28
You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect…
The correct answer is D. Run the SQL Access Advisor with a hypothetical workload. See the full explanation below for the reasoning.
Question
You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this?
Options
- ARun Segment Advisor.
- BRun the SQL Tuning Advisor (STA).
- CRun the Automatic Workload Repository (AWR) report.
- DRun the SQL Access Advisor with a hypothetical workload.
How the community answered
(41 responses)- A2% (1)
- B5% (2)
- C10% (4)
- D83% (34)
Community Discussion
No community discussion yet for this question.