Oracle Database Performance and Tuning Essentials 2015

Here you have the best Oracle 1z0-417 practice exam questions

You have 82 total questions to study from
Each page has 5 questions, making a total of 17 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 30, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 82

What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.

After a SQL Profile is created, it will then run efficiently for the life of the database.

The SQL Profile rewrites the SQL Statement issued by the application so it appears to the Optimizer as a perfectly written SQL statement.

You can have only one SQL Profile active at one time for a single SQL statement.

You need Oracle Database 12c or later to use SQL Profiles.

SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack is licensed.

Correct Answer: A, D

Question 2 of 82

Which two would automatically create an entry in V$SQL_MONITOR?

a parallelized SQL statement

any SQL statement run

any DML statement

a statement that consumes at least 1 second of CPU or I/O time.

a statement that consumes at least 5 second of CPU or I/O time.

any DDL statement

Correct Answer: C, F

Question 3 of 82

Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?

Review Operating System processes for any zombies.

Review SQL statistics from the Automatic Workload Repository (AWR).

Run a STATSPACK report.

Review Automatic Database Diagnostic (ADDM) recommendations.

Review all system configuration parameters.

Correct Answer: C, D

Question 4 of 82

, assigns an incident number and diagnostic data when a critical error occurs.
What is the feature and where does it store that data?

Oracle Enterprise Manager. Data is stored in the OEM Repository.

MyOracle Support. Data is stored in Oracle Cloud.

Automatic Workload Repository. Data is stored in views inside the Oracle database.

Automatic Diagnostic Repository. Data is stored in views inside the Oracle database.

Automatic Diagnostic Repository. Data is stored in a file-based repository outside the database.

Correct Answer: E

Question 5 of 82

Which two could Oracle Database Replay is used to validate performance?

applying workload to an application after an operating system patch

applying a workload from one database release to another database release

moving a workload from a single database instance and applying it to an Oracle Real Application Cluster (RAC)

to check and compare if a specific set of SQL statements have regressed between two different database releases

to find the least-used SQL statement

Correct Answer: A, C