Oracle Database: 1Z0-417

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.

Which three issues can be addressed with an Oracle Database Performance and Tuning solution?

A. erratic or inconsistent database performance

B. declining database responsiveness

C. unlimited I/O

D. fragmented database tables

E. database registry errors

F. database replication

In an Active Session History report, which response is correct?

A. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.

B. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.

C. ASH data is available 24 hoursbecause AWR snapshots refresh every night.

D. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.