OCP题库更新，新版052考试题和答案（58）

58、Examine this session output:

SQL> connct scott/tiger

Connected.

SQL> select name,value from V$parameter where name='audit_trail';

NAME VALUE

--------------- -----------------

audit_trail DB

SQL> audit all on emp;

audit successded.

Which two will generate an audit record?

• A. every DDL statement executed by SCOTT that affects SCOTT.EMP

• B. every UPDATE statement executed by SCOTT that updates SCOTT.EMP

• C. only the first SELECT statement executed by SCOTT is a session on SCOTT.EMP

• D. only the first DML statement executed by SYSTEM in a session on SCOTT.EMP

• E. every UPDATE statement executed by SCOTT that updates HR.EMP

• F. any DML statement executed by SYS on SCOTT.EMP

• Correct Answer: AB

北京CUUG整理，转载请注明，OCP讨论组：569933648/836361015

 

转载于:https://my.oschina.net/u/3946119/blog/2052224