It is more faster and easier to pass the Oracle 1Z0-417 exam by using Pinpoint Oracle Database Performance and Tuning Essentials 2015 questuins and answers. Immediate access to the Up to the minute 1Z0-417 Exam and find the same core area 1Z0-417 questions with professionally verified answers, then PASS your exam with a high score now.

Q11. At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager? 

A. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics. 

B. The configuration of their databases is incorrect and should be set toNOT_TYPICAL. 

C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality. 

D. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics. 

Answer:


Q12. Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another? 

A. SQLHints 

B. Stored Outlines 

C. Stored Profiles 

D. SQL Plan Management 

E. SQL Profiles 

Answer:

Explanation: 

SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed plan. Reference: https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm 


Q13. Which two would automatically create an entry inV$SQL_MONITOR? 

A. a parallelized SQL statement 

B. any SQL statement run 

C. any DML statement 

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

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

F. any DDL statement 

Answer: C,F 

Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789 


Q14. Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture? 

A. Oracle Diagnostic Pack for Database 

B. Real Application Testing 

C. Oracle Migration Pack for Databases 

D. Oracle Migration Performance Advisor 

E. SQL Performance Testing Suite 

Answer:


Q15. DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem? 

A. Complete Oracle Enterprise Manager suite 

B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes 

C. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance 

D. Oracle Database Backup & Recovery 

E. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production 

Answer:


Q16. You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of? 

A. total CPU time 

B. elapsed response time 

C. total time in database calls by all processes 

D. total time in V$ views 

E. time that users wait for the database to respond 

Answer:


Q17. Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM). 

A. log file sizing 

B. log buffer sizing 

C. log file problematic naming 

D. Mean Time to recover (MTTR) setting 

E. undersized SGA or PGA 

F. oversized SGA or PGA 

G. Less Time to recover (LTTR) setting 

Answer: D,E,F,G 


Q18. Which statement about Oracle Enterprise Manager Database Expressis correct? 

A. Oracle Enterprise Manager Database Control must be configured first. 

B. The listener needs to be running for it to be accessed. 

C. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first. 

D. Oracle Internet Application Server needs to be installed to use it. 

E. Oracle Enterprise Manager Database Express can be used only from a command-line. 

Answer:

Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/gettingstart ed/ gettingstarted.htm 


Q19. Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur? 

A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE. 

B. SetAUTO_UPDATE_STATISTICStoFALSE. 

C. Use aHOLD HINTin the SQL. 

D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE. 

Answer:


Q20. When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing? 

A. Result Cache 

B. Mega Cache 

C. Oracle In-Memory Database Cache 

D. Database Smart Flash Cache 

E. Oracle In-Memory DBSTATS Cache 

Answer: A,C,D