Examine the commands executed to monitor database operations: Which two statements
are true?
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.
Only a smiling visitant here to share the love (:, btw outstanding style.
http://www.bastcilkdoptb.com/
CE
https://docs.oracle.com/database/121/TDPPT/tdppt_realtime_dbops.htm#TDPPT532
A – FORCED_TRACKING=Y – this means that everything will be tracked, therefore A is wrong.
B – DBMS_SQL_MONITOR is for a single session only, therefore B is wrong.
C – correct.
D – Only DML is monitored, therefore D is wrong
E – Correct