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
Explanation:
Question is incorrect:
audit drop any table by scott by session whenever successful
*
ERROR at line 1:
ORA-32595: DDL statement cannot be audited with BY SESSION specified
This is valid however:
audit drop any table by steve by access whenever successful
*
By default, auditing will generate one audit record for every session that violates
an audit condition, irrespective of the number of times it violates the condition.
This is equivalent to appending BY SESSION to the AUDIT command. Appending
the keywords BY ACCESS to the AUDIT command will generate one record for
every violation.