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
This is the same as question 41, and the question is incorrect.
audit drop any table by scott by session whenever successful generates this error:
ERROR at line 1:
ORA-32595: DDL statement cannot be audited with BY SESSION specified