nerdexam
Oracle

1Z0-417 · Question #39

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that…

The correct answer is D. SQL Tuning Sets. See the full explanation below for the reasoning.

Question

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

Options

  • AOptimizer Statistics Comparator
  • BDynamic Baseline Advisor
  • CAutomatic Workload Repository Baselines
  • DSQL Tuning Sets
  • EDatabase Replay

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    12% (4)
  • C
    6% (2)
  • D
    79% (27)

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice