nerdexam
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)
  • A
    6% (2)
  • B
    81% (26)
  • C
    9% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-050 Practice