SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
A.
One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
B.
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
C.
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
D.
One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
E.
One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
A is the correct answer based on: http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_4007.htm
The extract of the web page is (For more details see the Oracle documentation):
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL) statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS specification.
I also thought ans was A.