Which are three use cases in which SQL Performance Analyzer can be used?

A. find and flashback explain plan anomalies

B. simulate Exadata on existing hardware

C. forecast impact of a system change on aSQL workload

D. compare performance of SQL statements before and after a change

E. debug SQL code syntax before and after a change

F. JSQL Heap Memory overflow testing

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

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.

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.

When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously?

A. CPU_NUM

B. NUM_CPU

C. MAX_CPU

D. LIMIT_CPU

E. CPU_COUNT

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

Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.

B. SetAUTO_UPDATE_STATISTICStoFALSE.

C. Use aHOLD HINTin the SQL.

D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.

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 Database 12c.

E. APEX is required to access ADDM.

Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

A. SQL Tuning Advisor

B. Automatic Workload Repository

C. Automatic Diagnostic Monitor

D. SQL Tuning SetE. SQL Error

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