Diagnosing the Database and Managing Performance - OCP: Oracle Database 12c Administrator Certified Professional - page 453

14. Which of these appropriately describes the results of a manual SQL Tuning Advisor task?
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and
after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it
implemented the recommended changes
D. All of the above
15. Which of the following is a potential performance tuning recommendation from the
SQL Access Advisor?
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
16. Which statement most accurately describes the implementation of a SQL Access Advisor
recommendation?
A. SQL Access Advisor recommendations are automatically implemented.
B. Individual SQL Access Advisor recommendations can be scheduled for implemen-
tation.
C. All SQL Access Advisor recommendations for a specific task must be implemented
at the same time.
D. SQL Access Advisor recommendations are automatically scheduled for implemen-
tation during the maintenance window.
E. None of the above
17. Which of the following represents the correct sequence of events for Database Replay?
A. Capture, analyze, preprocess, replay
B. Capture, preprocess, analyze, replay
C. Capture, preprocess, replay, analyze
D. Analyze, capture, preprocess, replay
E. None of the above