38.To make audit information more productive, the DBA executes the following command before starting
an audit operation:
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.
答案:B
SQL> show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
VALUE的含义如下
none:关闭审计
DB:启用审计,信息记录在SYS.AUD$中
OS:启用审计,审计信息保存在操作系统,oracle建议使用该配置
db,extended:启用审计,并且记录对应的执行语句
xml:启用审计,审计信息以xml形式保存在操作系统上
xml,extended:启用审计,并且包括所有的执行语句
an audit operation:
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.
答案:B
SQL> show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
VALUE的含义如下
none:关闭审计
DB:启用审计,信息记录在SYS.AUD$中
OS:启用审计,审计信息保存在操作系统,oracle建议使用该配置
db,extended:启用审计,并且记录对应的执行语句
xml:启用审计,审计信息以xml形式保存在操作系统上
xml,extended:启用审计,并且包括所有的执行语句