At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager?

A. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics.

B. The configuration of their databases is incorrect and should be set toNOT_TYPICAL.

C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.

D. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

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.

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

Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?

A. An invisible index is ignored by the optimizer.

B. After an index becomes invisible, it is no longer maintained during insertsand updates.

C. I/O bottlenecks are easy to spot when invisible indexes are used.

D. An index only needs to be rebuilt for it to be visible again.

E. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer.

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

A. LGWR

B. DBWR

C. CKPT

D. MMON

E. MMNL