Q1. Which two are functionalities of Oracle Real Application Testing? 

A. Database Replay 

B. SQL Query Sets (SQS) 

C. SQL Tuning Analyzer 

D. SQL Performance Analyzer (SPA) 

E. Real Application Cluster Replay 

View Answer

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

View Answer

Q3. Which two statements are true about Automatic Statistics collection by the Optimizer? 

A. Statistics are collected during automatic maintenance tasks. 

B. Any fixed objects are disregarded. 

C. Any external tables are incorporated. 

D. All tables in the data dictionary are included by defaults. 

E. Statistics are gathered after table statistics are marked stale. 

View Answer

Q4. Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another? 

A. SQLHints 

B. Stored Outlines 

C. Stored Profiles 

D. SQL Plan Management 

E. SQL Profiles 

View Answer

Q5. Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)? 

A. High Availability High Accessibility Architecture for Oracle Database 

B. Oracle Real Application Clusters 

C. Maximum Availability Architecture for Oracle Database 

D. Oracle Exadata 

E. Oracle Database 12c 

View Answer

Q6. For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality? 

A. to test performance after an upgrade to an Oracle Real Application Cluster 

B. to test performance of an Operating System patch 

C. to test effect of new Optimizer statistics 

D. to test performance after a database upgrade 

E. to test performance just after a database reboot 

View Answer

Q7. To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases? 

A. Cluster-wide performance analysis and reports with ADDM on issues that affect an entire databaseas wellas its individual instances. 

B. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times. 

C. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances. 

D. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache. 

E. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets. 

View Answer

Q8. You have been asked to provide a “technology update” to a long time Oracle Database customer. During the meeting, you are asked about Oracle Enterprise ManagerDatabase Express in Oracle Database 12c. 

Identify three of its capabilities you would share with the customer. 

A. Once Oracle Database 12c is installed, a DBA runs the separate Oracle Enterprise Manager DatabaseExpress installer to add it into the database console. 

B. The Oracle Enterprise Manager Database Express Performance HUB organizes and provides aconsolidated viewof real-time and historical performance data. 

C. The Database Express Performance HUB displays Oracle RAC specific metrics. 

D. Oracle Enterprise Manager Database Express can be extended by the user to also display Oracle 7-10gdatabases. 

E. Oracle Enterprise Manager Database Express does not require any separate middle-tier componentsbecause it uses XDB and SQL*NET. 

F. The Oracle enterprise Manager Database Express Performance Hub displays Oracle RAC specific metricswhen the optional RAC Pack is licensed. 

View Answer

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

View Answer

Q10. To analyze all database instances in an Oracle Real Application Cluster, in which mode would you run Automatic Database Diagnostic Monitor? 

A. INSTANCE 

B. DATABASE 

C. FULL 

D. CLUSTER 

E. PARTIAL 

F. ALL 

View Answer