Oracle
1Z0-050 · Question #10
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)
The correct answer is A. It produces less accurate results of the comparison analysis. C. It shortens the time of execution and reduces the impact on system resources. See the full explanation below for the reasoning.
Question
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)
Options
- AIt produces less accurate results of the comparison analysis.
- BIt automatically calls the SQL Tuning Advisor for recommendations.
- CIt shortens the time of execution and reduces the impact on system resources.
- DOnly the changes in the execution plan, and not performance regression, are detected.
How the community answered
(60 responses)- A73% (44)
- B12% (7)
- D15% (9)
Community Discussion
No community discussion yet for this question.