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 created for every session when any user successfully drops a table owned by SCOTT.
C:One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D:One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E:One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
出自:Oracle认证