147.You installed Oracle Database 11g afresh. Which statements are true regarding the default audit
settings in this database? (Choose all that apply.)
A. The audit trail is stored in an operating system file.
B. Auditing is disabled for all privileges.
C. The audit trail is stored in the database.
D. Auditing is enabled for all privileges.
E. Auditing is enabled for certain privileges related to database security.
Answer: CE
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12292365
如果数据库是使用D
at
ab
ase Configur
ation
Assist
ant (DBC
A) 创建的,默认
情况下,audit_trail参数设置为DB。
当
AUDIT_TR
AIL设置为DB时,默认的行为是将审计线索记录到
数据库的AUD$表中。(C正确)
默认审计
在Or
acle D
at
ab
ase 11g中启用审计时,将默认审计那些对安全性非常重要的特定权限和语句。(E正确)
系统将针对所有用户,按成功、失败以及访问来审计上面列出的这些权限和语句。