Which action can be performed by using Oracle Enterprise Manager Database Express Performance Hub? A. View health status and performance of an Oracle Database instance via Database Control. B. Launch and view STATSPACK reports. C. View real-time and historical Oracle…

Which is a feature of an Oracle Database Performance and Tuning implemented solution? A. a Documented Set of X$ and V$ Query Scripts B. a Maximum Availability Architecture C. a Documented Performance Methodology D. capability to Cloud Burst E. a…

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 of sequences outside of the database. B. Use Big…

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…

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…

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

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…

Which issue can be avoided by configuring the PCTFREE parameter? A. row chaining and setting it has been superseded by Automatic Segment Space Management B. table fragmentation, and has been superseded by Automatic Storage Management C. column fragmentation D. sort…

When reviewing a customer’s database configuration, you find that OPTIMIZER_USE_SQL_PLAN_BASELINES is set as TRUE. What does the Optimizer do? A. compares plans that it develops with accepted plans in baselines B. develops plans and adds them to baselines as verified…

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