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?

Question

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?

Accepted Answer

B. It contains the SQL text executed by the user and the bind variables used with it Setting AUDIT_TRAIL=DB,EXTENDED causes Oracle to write standard audit records to SYS.AUD$ and additionally populate the SQLTEXT column with the full SQL statement and the SQLBIND column with the bind variable values used at execution time. This provides the richest level of detail for standard auditing compared to DB alone.

Answer

A. It contains only the plan for the SQL statement executed by the user The DB,EXTENDED setting captures SQL text and bind variables, not execution plans; execution plans are accessed through DBMS_XPLAN or V$SQL_PLAN.

Answer

C. It contains the plan and statistics associated with the SQL statement executed by the user Execution plans and runtime statistics are not part of the audit trail; they are found in V$SQL and related dynamic performance views.

Answer

D. It contains the plan for the SQL statement executed by the user and the bind variables used with it The DB,EXTENDED setting does not capture execution plans at all; it captures SQL text together with bind variables, not plans with bind variables.

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…

Question

Options

How the community answered

Why each option

Topics

Community Discussion