Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER - SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (batch_job , FORCED_TRACKING => Y); Which two statements are true? (Choose two.) 

Answer options:

A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be monitored.

CE

C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. Note: * The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring. *(not B) BEGIN_OPERATION Function starts a composite database operation in the current session. / (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable `Y`. / (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable `N`.