Oracle
1Z0-514 · Question #71
In your database, the SQL Tuning Advisor is running automatically during the system maintenancewindow as a maintenance task. Which of its recommendations would be implemented automatically?
The correct answer is D. creation or modification of a SQL Profile. See the full explanation below for the reasoning.
Question
In your database, the SQL Tuning Advisor is running automatically during the system maintenancewindow as a maintenance task. Which of its recommendations would be implemented automatically?
Options
- Acreation of new Indexes
- Brefreshing optimizerstatistic\
- Crestructuring SQL statements
- Dcreation or modification of a SQL Profile
How the community answered
(39 responses)- A5% (2)
- B15% (6)
- C8% (3)
- D72% (28)
Community Discussion
No community discussion yet for this question.