Act now and download your Oracle 1Z0-417 test today! Do not waste time for the worthless Oracle 1Z0-417 tutorials. Download Improve Oracle Database Performance and Tuning Essentials 2015 exam with real questions and answers and begin to learn Oracle 1Z0-417 with a classic professional.
Q9. 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: B
Q10. 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: B
Q11. Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting?
A. variety of real-time reports once the Business Intelligence option is installed
B. reports in response to critical errors
C. reports with findings and recommendations to resolve problems
D. reports examining memory and process usage
E. historical reports after the Database Diagnostic Repository (DDR) is configured
F. reports examining user and developer SQL programming errors
Answer: B,E,F
Q12. 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
Q13. 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: C
Reference: http://dbaora.com/enterprise-manager-database-express-oracle-database-12c-release-1-12-1/
Q14. A customer has database performance issues within their Oracle Real Application Cluster. What is the next step?
A. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.
B. Use the application load testing utility to overload a copy of their application in development to flush out theissue.
C. Turnoff RAC interconnects to isolate any network issues impacting database performance problems.
D. Use a third-party RAC tool to identify the bad SQL and then rewrite it.
E. Utilize the Oracle Database Performance Method to help identify and correct issue.
Answer: E
Q15. 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 Operating System processes for any zombies.
B. Review SQL statistics from the Automatic Workload Repository (AWR).
C. Run a STATSPACK report.
D. Review Automatic Database Diagnostic (ADDM) recommendations.
E. Review all system configuration parameters.
Answer: C,D
Q16. 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?
A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
B. After a SQL Profile is created, it will then run efficiently for the life of the database.
C. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.
D. You can have only one SQL Profile active at one time for a single SQL statement.
E. You need Oracle Database 12c or later to use SQL Profiles.
F. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.
Answer: A,E