Exam information

Exam 1Z0-053: Oracle Database 11g, Administration II

Other exams

Which package provides API’s for the SQL Tuning Advisor?

Which package provides API’s for the SQL Tuning Advisor?

Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply

Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)

What would the optimizer do in this situation?

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

Which two statements about the SQL Management Base (SMB) are true? (Choose two

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

Which statement is true when you accept the suggested SQL profile?

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

Which two statements describe the implications of this? (Choose two

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?

To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?

Page 1 of 4012345...102030...Last »