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 the SQL text executed by the user and the bind variables used with it
B.
It contains the plan and statistics associated with the SQL statement executed by
the user
C.
It contains the plan for the SQL statement executed by the user and the bind
variables used with it
D.
It contains only the plan for the SQL statement executed by the user
A
A
https://docs.oracle.com/cloud/latest/db112/REFRN/initparams017.htm#REFRN10006
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.
If the database was started in read-only mode with AUDIT_TRAIL set to db, extended, then Oracle Database internally sets AUDIT_TRAIL to os. Check the alert log for details.