You execute the following command to audit the database activities:
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 the whole session if user SCOTT successfully drops one or more tables in his session.
B.
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
C.
One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
D.
One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
E.
One audit record is created for every session when any user successfully drops a table owned by SCOTT.
The difference between BY SESSION and BY ACCESS is that when you specify BY SESSION Oracle will try to merge multiple audit entries into one record when the session and the action audited match.