Which two statements are true about viewing the details of Real-Time Database
Operations?(Choose two.)
A.
InV$SQL_MONITORmonitoring, statistics are cumulative over several executions of the
SQL statement that is being monitored in a session.
B.
SQL Developer can be used to view running database operations.
C.
Oracle Enterprise Manager Database Express can be used to view running database
operations.
D.
When the SQL statement that is being monitored is executing,V$SQL_MONITORis
refreshed once every minute. After the execution ends, the monitoring information
inV$SQL_MONITORis deleted immediately.
E.
Oracle Enterprise Manager Cloud Control can be used to view running database
operations.
Explanation:
http://www.dbaref.com/monitoring-active-sql
A wrong, each sql statement has its own entry and set of statistics
D wrong, information is not deleted immediately after execution ends
E obviously correct.
Hesitate between B and C.
I think C is correct. OEM Database Express has performance hub page and there is an activity tab.
So C and E.
C,E
CE clearly