nerdexam
Oracle

1Z0-417 · Question #71

For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

The correct answer is C. to test effect of new Optimizer statistics. See the full explanation below for the reasoning.

Question

For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

Options

  • Ato test performance after an upgrade to an Oracle Real Application Cluster
  • Bto test performance of an Operating System patch
  • Cto test effect of new Optimizer statistics
  • Dto test performance after a database upgrade
  • Eto test performance just after a database reboot

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    10% (3)
  • C
    77% (24)
  • D
    6% (2)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice