Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements. 

Answer options:

A. Change in the Oracle Database version
B. Change in your network infrastructure
C. Change in the hardware configuration of the database server
D. Migration of database storage from non-ASM to ASM storage
E. Database and operating system upgrade

ACE

Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as: ✑ (E) Database, operating system, or hardware upgrades. ✑ (A, C) Database, operating system, or hardware configuration changes. ✑ Database initialization parameter changes. ✑ Schema changes, such as adding indexes or materialized views. ✑ Refreshing optimizer statistics. ✑ Creating or changing SQL profiles.