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

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 TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()

  • A One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
  • B One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
  • C One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
  • D One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
  • E One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
参考答案
参考解析:
分类: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 commands executed to moni

Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS...

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 plan to execute the following com

You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDAT...

5、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...

6、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...