Oracle
1Z0-417 · Question #23
Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?
The correct answer is A. measuring performance before and after the change C. identifying the SQL statements that regressed or improved D. providing tuning recommendations for each SQL statement that is regressed. See the full explanation below for the reasoning.
Question
Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?
Options
- Ameasuring performance before and after the change
- Bgenerating a list of SQL Hints that the Optimizer will use to improve overall performance
- Cidentifying the SQL statements that regressed or improved
- Dproviding tuning recommendations for each SQL statement that is regressed
- Emeasuring performance and comparing to industry benchmarks (TPC-C, TPC-D)
- Fmeasuring a change in user session logins
How the community answered
(49 responses)- A84% (41)
- B10% (5)
- E4% (2)
- F2% (1)
Community Discussion
No community discussion yet for this question.