Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 9 of 40

Marks: +1, -0

Examine the commands executed to monitor database operations:

$ > conn sys/oracle@prod as sysdba  
 SQL > VAR eid NUMBER  
 SQL >EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');

Which two statements are true? (Choose two.)

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

Go to Question:

Prev Question

Next Question