1Z0-417 | The Up to date Guide To 1Z0-417 exam dumps
Q11. 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
Q12. Which statement is true about implementation of an Oracle Database Performance and Tuning solution?
A. It is available for Oracle Database Standard and Enterprise Editions.
B. It is applicable for Oracle Database 12c and later versions.
C. It builds on capabilities built into Oracle databases.
D. It is recommended for Production environments, but not for Development or QA.
E. It is delivered with Oracle Engineered Systems.
Answer: E
Q13. 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
Q14. DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him – Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?
A. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing.
B. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.
C. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.
D. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.
E. With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots byusing SQL. If you use anything else, then you need an additional license.
Answer: C
Q15. For which one would you use an index fast full scan to improve performance?
A. a query having all the columns of an index in the where clause
B. a query that does not need to access table rows
C. a query that needs to access table rows along with an index
D. a column in an index that is compressed
Answer: A
Explanation:
All of the columns required by SQL must reside in the index tree; that is, all columns in the SELECT and WHERE clauses must exist in the index. Reference: http://www.dba-oracle.com/t_index_fast_full_scan.htm
Q16. 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
Q17. A customer seeks capability to measure and test database performance before and after application changes. Which would you implement to meet that requirement?
A. Oracle Performance Analyzer
B. Oracle Application Performance Analyzer
C. Oracle Real Application Testing
D. Oracle SQL Developer
E. Oracle Spatial and Graph
Answer: E
Q18. 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 smaller database block size.
B. Use larger database block size.
C. Use direct-path inserts wherepossible.
D. IncreasePCTFREEon the table segment.
E. Increase the size of the tablespace.
Answer: A,E
Q19. Select two scenarios that an Oracle Database Performance and Tuning solution implementation addresses.
A. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.
B. An HR Team claims that it can hire staff fast enough to meet business demands.
C. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.
D. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.
E. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.
Answer: B,C
Q20. 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