多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • 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.
正确答案:C,E
答案解析:
进入题库查看解析

微信扫一扫手机做题