Q1. 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.
Answer: F
Q2. 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
Q3. 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.
Answer: C,D
Q4. 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
Answer: B
Explanation:
Oracle Real Application Clusters (Oracle RAC) is a clustered version of Oracle Database based on a comprehensive high-availability Reference: http://www.oracle.com/us/products/database/options/real-application-clusters/overview/index.html
Q5. For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?
A. to determine if objects have unusedspace that can be released
B. to advise if materialized views can be used to reduce size of views
C. to review space usage of individual schema objects or tablespaces
D. to advise if there are any duplicate indexes and automate their removal
E. to identify any fragmentation in the database cache or swap space
Answer: A,C
Q6. Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?
A. Implement primary and foreign keys, enforce database integrity, joins, message queuing, maintenance ofsequencesoutside of the database.
B. Use Big Data to hold everything into one big table.
C. Maintain and analyze performance statistics using AWR and ADDM.
D. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution.
E. Perform testing with Real Application Testing.
Answer: A,C,E
Q7. Which product technology can assist an Application Developer to capture a full production workload and replay on a test system database?
A. Oracle Database Diagnostics Pack for Oracle Database
B. Oracle Database Replay and Testing Suite
C. Oracle SQL Developer
D. Oracle Real Application Testing
E. Oracle Real Tuning Pack for Oracle Database
Answer: D
Q8. 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.
Answer: A
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. 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
Answer: B,C,D