Which three methods can you use to create a pre-change …

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL
Performance Analyzer? (Choose three.)

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL
Performance Analyzer? (Choose three.)

A.
executing SQL statements in an SQL Tuning Set (STS) on a test database by using database links to the
production database.

B.
generating only execution plans on a test database without actually running SQL statements.

C.
generating an execution plan and statistics for selective SQL statements captured in an STS

D.
loading performance data and execution plans from an STS.

E.
generating both execution plans and statistics for each SQL statement in an STS by actually running the
SQL statements on a test database.

Explanation:
https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG181



Leave a Reply 0

Your email address will not be published. Required fields are marked *