Q1. Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?
A. Use smaller database block size.
B. Use larger database block size.
C. Use direct-path inserts wherepossible.
D. IncreasePCTFREEon the table segment.
E. Increase the size of the tablespace.
Answer: A,E
Q2. Upon implementation completion, which three should be reviewed with a customer to confirm the values or benefits of a Oracle Database Performance and Tuning solution?
A. real-time and historical monitoring capabilities
B. non-intrusive metric collections
C. statspack integration and support
D. integration with Enterprise Manager
E. included scripts for querying X$ and V$ views
F. SQL script code management capabilities
Answer: A,B,D
Q3. DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem?
A. Complete Oracle Enterprise Manager suite
B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes
C. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance
D. Oracle Database Backup & Recovery
E. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production
Answer: B
Q4. 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.
Answer: B,C
Q5. A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?
A. It is the total time spent in database calls by all sessions in the database.
B. It is the total time spent in database calls by foreground sessions in the database.
C. It is the total time spent in database calls by background sessions in the database.
D. It includes non-idle wait time.
E. It is the overall response time.
F. It includes login, idle, background, and Zombie session wait time.
Answer: B,C
Q6. The IT team said that a system appeared OK based on their third-party network and systems management tool; yet customers continue to complain of database performance-related issues. Which two would you implement to find and fix the problem?
A. Oracle Real User Experience Insight
B. Oracle Application Testing Suite
C. Oracle Exadata
D. Oracle Real Application Clusters
E. Oracle Diagnostic and Tuning Pack for Oracle Database
Answer: D,E
Q7. Which four use cases could Database Replay be used to test for database performance changes?
A. a change in operating system versions
B. compare Flashback workload
C. check a workload from a single instance on an Oracle RAC database
D. check a workload after database parameters have been changed
E. check a workload from one database release on another database released
F. upgrade an application
Answer: B,C,D,E
Q8. To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed?
A. Oracle Diagnostics Pack for Oracle Databases
B. Oracle Tuning Pack for Oracle Databases
C. Oracle Diagnostics and Tuning Pack for Oracle Databases
D. Oracle ADDM Pack
E. Nothing else needs to be licensed.
Answer: C
Q9. A customer seeks capability to measure and test database performance before and after application changes. Which would you implement to meet that requirement?
A. Oracle Performance Analyzer
B. Oracle Application Performance Analyzer
C. Oracle Real Application Testing
D. Oracle SQL Developer
E. Oracle Spatial and Graph
Answer: E
Q10. Which three are benefits of implementing an Oracle Database Performance and Tuning solution?
A. automated database diagnostics based on deep database kernel integration
B. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information
C. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer
D. the most extensive and up-to-date collection of database monitoring and tuning scripts
E. built-in instrumentation, real-time and historical monitoring, and data collection
F. a performance methodology
Answer: D,E,F