Oracle
1Z0-417 · Question #42
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
The correct answer is A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a D. You can have only one SQL Profile active at one time for a single SQL statement. See the full explanation below for the reasoning.
Question
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?
Options
- AYou need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a
- BAfter a SQL Profile is created, it will then run efficiently for the life of the database.
- CThe SQL Profile rewrites the SQL Statement issued by the application so it appears to the
- DYou can have only one SQL Profile active at one time for a single SQL statement.
- EYou need Oracle Database 12c or later to use SQL Profiles.
- FSQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack
How the community answered
(38 responses)- A84% (32)
- B5% (2)
- C3% (1)
- F8% (3)
Community Discussion
No community discussion yet for this question.