We provide real 1Z0-417 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-417 Exam quickly & easily. The 1Z0-417 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-417 dumps pdf and vce product and material, you can easily pass the 1Z0-417 exam.

Q1. When reviewing a customer's database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do? 

A. compares plans that itdevelops with accepted plans in baselines 

B. develops plans and adds them to baselines as verified 

C. doesn't develop an execution plan, but uses an accepted plan from baselines 

D. doesn't develop an execution plan, but uses enabled plans in the baseline 

Answer:


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


Q3. Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)? 

A. ADDM analyzes information in RMAN. 

B. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM. 

C. ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR). 

D. ADDM and AWR are new features of Oracle Database 12c. 

E. APEX is required to access ADDM. 

Answer:


Q4. 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:


Q5. As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express? 

A. SQL Developer 

B. SQL Plus 

C. Database console 

D. SQL Express 

E. Grid Control 

Answer:

Reference: http://dbaora.com/enterprise-manager-database-express-oracle-database-12c-release-1-12-1/ 


Q6. 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. Active Workload History to collect SQL at the time of its execution. 

B. SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing. 

C. Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached. 

D. Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis. 

E. Active SQL History Analyzer to doperform a comparison of SQL statements before and after. 

F. Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database. 

Answer:


Q7. Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload? 

A. measuring performance before and after the change 

B. generating a list of SQL Hints that the Optimizer will use to improve overall performance 

C. identifying the SQL statements that regressed or improved 

D. providing tuning recommendations for each SQL statement that is regressed 

E. measuring performance and comparing to industry benchmarks (TPC-C, TPC-D) 

F. measuring a change in user session logins 

Answer: A,C,E 


Q8. SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations? 

A. Materialized views 

B. Indexes 

C. Partitions 

D. Tablespaces 

E. V$ performance views 

F. Hints 

Answer: B,D,E 


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


Q10. Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise. 

Which are two actions you would take to meet the customer's requirements? 

A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0. 

B. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot. 

C. Using the appropriate architectureimplement Oracle Enterprise Manager. 

D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express. 

E. Changes permissions of the “express” directory to real only by root. 

F. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps. 

Answer: B,E