Exit 1Z0-1093-25 Oracle Cloud Database Services 2025 Professional
Question 3 of 5
0% complete
Q3 Multiple choice

Which two functionalities are provided by the SQL Performance Analyzer (SPA) within Database Management, aiding in cloud database tuning?

Select all that apply.

  • A

    Automatically rewrite SQL queries to improve their performance.

  • B

    Compare the performance of SQL statements before and after a database change (e.g., upgrade, parameter change).

  • C

    Generate a report highlighting the performance impact of a specific database change on a set of SQL statements.

  • D

    Analyze the execution plan of a SQL statement and suggest alternative indexing strategies.