To make audit information more productive, the DBA executes the following command before
starting an audit operations:
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting
the database?
A.
It contains only the plan for the SQL statement executed by the user
B.
It contains the SQL text executed by the user and the bind variables used with it
C.
It contains the plan and statistics associated with the SQL statement executed by the user
D.
It contains the plan for the SQL statement executed by the user and the bind variables used with
it
AUDIT_TRAIL enables or disables database auditing.
The following statement sets the db, extended value for the AUDIT_TRAIL parameter. The new value takes effect after the database is restarted.
SQL> alter system set AUDIT_TRAIL=db, extended scope=spfile;
System altered
===========================================================
db, extended:
Performs all actions of AUDIT_TRAIL=db, and also populates the SQL bind and SQL text CLOB-type columns of the SYS.AUD$ table, when available. These two columns are populated only when this parameter is specified.
Performs all actions of AUDIT_TRAIL = db, and also populates the SQL bind variable and SQL text CLOB-type columns … These two columns are populated only when this parameter is specified.
SQL – BIND (NO PLAN)
SQL – TXT – BIND