Free Oracle 1z0-417 Exam Dumps Questions & Answers


Exam Code/Number:	1z0-417Join the discussion
Exam Name:	Oracle Database Performance and Tuning Essentials 2015
Certification:	Oracle
Free Question Number:	85
Publish Date:	Oct 06, 2026
# of views:	4239
Rating 100%

Page: 1 / 17
Total 85 questions

Question 1

For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?

A.to advise if there are any duplicate indexes and automate their removal
B.to review space usage of individual schema objects or tablespaces
C.to identify any fragmentation in the database cache or swap space
D.to determine if objects have unusedspace that can be released
E.to advise if materialized views can be used to reduce size of views

Question 2

IT Operations had observed short CPU spikes and I/O storms prior to a retail website outage. Which functionality of Diagnostics Pack for Oracle Databases would you implement to diagnose and resolve the customers issue?

A.Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached.
B.Active Workload History to collect SQL at the time of its execution.
C.SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing.
D.Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis.
E.Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.
F.Active SQL History Analyzer to doperform a comparison of SQL statements before and after.

Question 3

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?

A.Review SQL statistics from the Automatic Workload Repository (AWR).
B.Run a STATSPACK report.
C.Review Operating System processes for any zombies.
D.Review all system configuration parameters.
E.Review Automatic Database Diagnostic (ADDM) recommendations.

Question 4

Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

A.Use direct-path inserts wherepossible.
B.IncreasePCTFREEon the table segment.
C.Use larger database block size.
D.Increase the size of the tablespace.
E.Use smaller database block size.

Question 5

Which statement about Oracle Enterprise Manager Database Expressis correct?

A.The listener needs to be running for it to be accessed.
B.Oracle Internet Application Server needs to be installed to use it.
C.Oracle Enterprise Manager Database Control must be configured first.
D.A Oracle Enterprise Manager Database Express WebLogic Server must be configured first.
E.Oracle Enterprise Manager Database Express can be used only from a command-line.