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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31550393/viewspace-2214271/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31550393/viewspace-2214271/