It is more faster and easier to pass the Oracle 1Z0-417 exam by using High quality 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.


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-417 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-417 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-417-exam-dumps.html

Q1. Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance? 

A. Wait Event statistics 

B. Session and System statistics 

C. User privileges statistics 

D. Standby Database throughput statistics 

E. Interconnect statistics 

Answer: A,D 

Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 


Q2. When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously? 

A. CPU_NUM 

B. NUM_CPU 

C. MAX_CPU 

D. LIMIT_CPU 

E. CPU_COUNT 

Answer:

Reference: http://docs.oracle.com/html/E25494_01/dbrm008.htm 


Q3. An advanced fault diagnostic infrastructure introduced as of Oracle Database 11g, assigns an incidentnumber and diagnostic data when a critical error occurs. What is the feature and where does it store that data? 

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

B. MyOracle Support. Data is stored in Oracle Cloud. 

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

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

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

Answer:

Explanation: 

The data is then stored in the Automatic Diagnostic Repository (ADR) — a file-based repository outside the database 

Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm 


Q4. Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions? 

A. The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console. 

B. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt. 

C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING. 

D. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view. 

E. A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews. 

Answer: C,D 


Q5. Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance? 

A. lock out user sessions and gather system statistics overnight 

B. gather system statistics after a performance issue has been reported 

C. gather system statistics for several hours when there is no workload 

D. gather system statistics for several hours during normal workload periods 

E. shut down any running applications prior to collection 

Answer:

Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL398 


Q6. When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration? 

A. SQL Tuning Pack for Oracle Database 

B. Oracle Tuning Pack for Oracle Database 

C. Oracle Performance Pack for Oracle Database 

D. Oracle Diagnostics Pack for Oracle Database 

E. Oracle Real Application Testing 

F. Oracle SQL Developer 

G. STATSPACK 

Answer: B,D,E 

Reference: http://www.oracle.com/partners/en/most-popular-resources/db-performance-tuning-study-guide2138991.pdf (See page #03, Application product technology subject areas include). 


Q7. Which four use cases could Database Replay be used to test for database performance changes? 

A. a change in operating system versions 

B. compare Flashback workload 

C. check a workload from a single instance on an Oracle RAC database 

D. check a workload after database parameters have been changed 

E. check a workload from one database release on another database released 

F. upgrade an application 

Answer: B,C,D,E 


Q8. A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it? 

A. It is the total time spent in database calls by all sessions in the database. 

B. It is the total time spent in database calls by foreground sessions in the database. 

C. It is the total time spent in database calls by background sessions in the database. 

D. It includes non-idle wait time. 

E. It is the overall response time. 

F. It includes login, idle, background, and Zombie session wait time. 

Answer: B,C 


Q9. For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality? 

A. to test performance after an upgrade to an Oracle Real Application Cluster 

B. to test performance of an Operating System patch 

C. to test effect of new Optimizer statistics 

D. to test performance after a database upgrade 

E. to test performance just after a database reboot 

Answer:


Q10. 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