Q1. An Oracle Database customer's VP of Development mentions that they've moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement?
A. Oracle Application Infrastructure Tester
B. Oracle Application Testing Suite
C. SQL Developer
D. Oracle Real Application Testing
E. APEX and SQL Developer
F. Oracle Testing Pack
Answer: B,D
Q2. 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
Q3. Which option do customers need to license in order to implement SQL Performance Analyzer and Database Replay functionalities?
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 SQL Tuning Pack for Oracle Database
Answer: D
Reference: https://docs.oracle.com/cd/B19306_01/license.102/b14199/options.htm
Q4. 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
Answer: A
Reference: http://docs.oracle.com/cd/E25178_01/server.1111/e16638/diag.htm
Q5. You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?
A. Optimizer Statistics Comparator
B. Dynamic Baseline Advisor
C. Automatic Workload Repository Baselines
D. SQL Tuning Sets
E. Database Replay
Answer: D
Q6. A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?
A. It enables you to conduct performance analysis of long-running sessions.
B. It enables you to conduct performance analysis of transient issues.
C. In memory, active sessions are sampled every second.
D. It accesses database kernel structures indirectly via the buffer cache.
E. It enables you to look at all database sessions since the database was created.
Answer: A,C
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_method.htm#TDPPT015
Q7. What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
A. With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption.
B. Oracle Databases are constantly changing; more users, data added and deleted, varying SQL atapplication level.
C. Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current.
D. Inefficient “Bad” application SQL can be detected by Diagnostics Pack and then optimized utilizing TuningPack SQL Profiles, even if it can't be changed at the application end.
E. Diagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database EnterpriseEdition.
Answer: C,E
Q8. 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
Answer: C,D
Q9. Which two statements are true about Oracle Enterprise Manager Database Express?
A. It uses internal infrastructure components, such as XDB and SQL*NET.
B. It can perform actions inside and outside the database.
C. Performance Hub and Composite Active Reports are its key functionalities.
D. It is not supported on Oracle Standard Edition or Express Edition.
E. It replaces Oracle Grid Control.
Answer: A,C
Reference: http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html
Q10. 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
Answer: C
Explanation:
SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed plan. Reference: https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm