Database Performance and Tuning Essentials 2015 試験
Question No : 1
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.
Question No : 2
Which three issues can be addressed with an Oracle Database Performance and Tuning solution?
Question No : 3
When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?
Question No : 4
What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
Question No : 5
Which are two characteristics of “invisible” index functionality that would help tune a database having thousands of legacy indexes?
Question No : 6
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?
Question No : 7
A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?
Question No : 8
Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?
Question No : 9
Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?
Question No : 10
Which option would you use to capture workloads from one or more systems concurrently and then play them back?
Question No : 11
When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?
Question No : 12
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed plan.
Question No : 13
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individual database 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?
Question No : 14
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?
Question No : 15
You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?