052-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.

AUDIT_TRAIL 值含义如下:
DB:启用审计,信息记录在 SYS.AUD$中
OS:启用审计,审计信息保存在操作系统,Oralce 建议使用该配置
Db,extended:启用审计,并且记录对应的执行语句
Xml:启用审计,审计信息以 xml 形式保存在操作系统上
Xml,extended:启用审计,并且包括所有的执行语句

posted @ 2017-12-05 16:39  巴啦啦大魔王  阅读(75)  评论(0编辑  收藏  举报