可学答题网 > 问答 > 1Z0-060题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the commands executed to moni


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.
参考答案
参考解析:
分类:1Z0-060题库
相关推荐

1、You executed the following commands i

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()A There is demand for space f...

2、Examine the following impdp command to

Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites ...

3、The following command is executed to

The following command is executed to create the baseline template:Which statement is true about the effect of the above command?()A It creates...

4、You execute the following commands to

You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL > AUDIT SELECT TA...

5、Examine the command: 

Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true&...

6、You executed the following command: R

You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above...