Oracle
1Z0-050 · Question #34
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
The correct answer is B. SQL statements based on the AWR top SQL identification. See the full explanation below for the reasoning.
Question
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
Options
- ASQL statements that are part of the AWR baseline only
- BSQL statements based on the AWR top SQL identification
- CSQL statements that are part of the available SQL Tuning Set (STS) only
- DSQL statements that are available in the cursor cache and executed by a user other than SYS
How the community answered
(32 responses)- A6% (2)
- B81% (26)
- C9% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.