You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER
SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?
A.
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command
on a table, and contains the SQL text for the SQL Statements.
B.
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command,
and contains the execution plan for the SQL statements.
C.
One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command, and contains the execution plan for the SQL statements.
D.
One audit record is created for the whole session if JOHN successfully executes a select command, and
contains the SQL text and bind variables used.
E.
One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.