Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR)

Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR)you would utilize when tuning an Oracle Database instance? A. Wait Event statistics B. Session and System statistics C. User privileges statistics D. Standby Database throughput statistics E. Interconnect statistics Explanation: Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 Show Answer

Read More

Which statement about Oracle Enterprise Manager Database Express is correct?

Which statement about Oracle Enterprise Manager Database Express is correct? A. Oracle Enterprise Manager Database Control must be configured first. B. The listener needs to be running for it to be accessed. C. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first. D. Oracle Internet Application Server needs to be installed to […]

Read More

Which three capabilities can be used to automate reporting?

Oracle databases come with a built-in health monitor to run diagnostic checks on components of thedatabase. 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 […]

Read More

Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)?

Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)? A. ADDM analyzes information in RMAN. B. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM. C. ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR). D. ADDM and AWR are new features of Oracle […]

Read More

Which would you implement to meet that requirement?

A customer seeks capability to measure and test database performance before and after applicationchanges. 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 Explanation: Show Answer

Read More

What is DB Time% a percentage of?

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 Explanation: Show Answer

Read More