Q1. Which one is a type of user session and client request supported by Database Replay?
A. XA transactions
B. Oracle Call Interface (OCI) based object navigations
C. SQL-based object access
D. Flashback queries
E. Database Resident Connection Pooling (DRCP)
Answer: C
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_capture.htm#RATUG115
Q2. Which option would you use to capture workloads from one or more systems concurrently and then play them back?
A. Automatic Workload Repository
B. Enterprise Manager Cloud Control
C. Consolidated Database Replay
D. Consolidation Planner
E. Workload Consolidator and Playback
Answer: C
Q3. 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
Answer: B,E,F
Q4. Which is the default statistics gatheringperiod for Automatic Database Diagnostics Monitoring (ADDM)?
A. every 30 seconds
B. every 60 minutes
C. every 30 minutes
D. every 24 hoursE. every 40 hours
Answer: A
Q5. Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?
A. CPU
B. concurrent sessions
C. SGA
D. network I/O
E. ability to use parallel server processes
F. use of SGA memory and ability to allocate PGA
Answer: A,B,E
Explanation: Section: (none) Explanation
Q6. Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?
A. Review Operating System processes for any zombies.
B. Review SQL statistics from the Automatic Workload Repository (AWR).
C. Run a STATSPACK report.
D. Review Automatic Database Diagnostic (ADDM) recommendations.
E. Review all system configuration parameters.
Answer: C,D
Q7. You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?
A. total CPU time
B. elapsed response time
C. total time in database calls by all processes
D. total time in V$ views
E. time that users wait for the database to respond
Answer: C
Q8. What are three reasons an implementation of an Oracle Database Performance and Tuning solution is superior to that of scripts or third-party tools?
A. It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.
B. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.
C. It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.
D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.
E. It is the most inexpensive tool in the market.
Answer: B,D,E
Q9. When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?
A. SQL Tuning Pack for Oracle Database
B. Oracle Tuning Pack for Oracle Database
C. Oracle Performance Pack for Oracle Database
D. Oracle Diagnostics Pack for Oracle Database
E. Oracle Real Application Testing
F. Oracle SQL Developer
G. STATSPACK
Answer: B,D,E
Reference: http://www.oracle.com/partners/en/most-popular-resources/db-performance-tuning-study-guide2138991.pdf (See page #03, Application product technology subject areas include).