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.
Which are three use cases in which SQL Performance Analyzer can be used?
A. find and flashback explain plan anomalies
B. simulate Exadata on existing hardware
C. forecast impact of a system change on aSQL workload
D. compare performance of SQL statements before and after a change
E. debug SQL code syntax before and after a change
F. JSQL Heap Memory overflow testing
Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?
A. Hash Partitioning
B. Reference Partitioning
C. Composite Partitioning
D. Interval Partitioning
E. Disk Partitioning
Which is a prerequisite for using an Oracle Database Performance and Tuning solution?
A. Linux Operating system
B. 8 GB of memory
C. Oracle Database Enterprise Edition
D. Oracle Enterprise Manager
E. deep knowledge of Oracle Storage subsystems
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
Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?
A. LGWR
B. DBWR
C. CKPT
D. MMON
E. MMNL
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?
A. memory
B. CPU
C. Parallel Execution Servers
D. shares of systemresources
E. number of users
F. number of tables or indexes
G. number of indexes
In an Active Session History report, which response is correct?
A. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.
B. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.
C. ASH data is available 24 hoursbecause AWR snapshots refresh every night.
D. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.
Which is a feature of an Oracle Database Performance and Tuning implemented solution?
A. a Documented Set of X$ and V$ Query Scripts
B. a Maximum Availability Architecture
C. a Documented Performance Methodology
D. capability to Cloud Burst
E. a Documented Performance Response Method
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.