nerdexam
Oracle

1Z0-062 · Question #36

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to

Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.

Managing Performance

Question

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?

Options

  • ADatabase replay
  • BSQL Tuning Advisor
  • CSQL Access Advisor
  • DSQL Performance Analyzer
  • EAutomatic Workload Repository compare reports

Unlock 1Z0-062 to see the answer

You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#SQL Performance Analyzer#Workload performance#Schema changes#Performance impact analysis
Full 1Z0-062 Practice