Oracle Database Administration 2022 Certified Professional — Question 10

For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance? (Choose two.)

Answer options

• A. storage, network, and interconnect changes
• B. operating system upgrades
• C. changes to database initialization parameters
• D. database consolidation for pluggable databases (PDBs)
• E. operating system and hardware migrations

Correct answer: C, D

Explanation

SQL Performance Analyzer is specifically designed to evaluate changes in database initialization parameters and the consolidation of pluggable databases (PDBs), which can significantly impact SQL performance. The other options, while related to the overall environment, do not directly relate to SQL performance assessment in the same manner.