（39）Which two statements are true about standard database auditing? (Choose two.)

A.DDL statements can be audited.

B.Statements that refer to stand-alone procedure can be audited.

C.Operations by the users logged on as SYSDBA cannot be audited.

D.Only one audit record is ever created for a session per audited statement even though it is executed more than once.

答案：（A、B）
解析：
C（X），以SYSDBA身份登录的用户的操作是可以被审计的，前提是设置AUDIT_SYS_OPERATIONS = TRUE
D（X），在11g中，即使对审计选项设置了by session，仍然按by access来执行
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation. BY SESSION continues to populate different values to the audit trail compared with BY ACCESS. Oracle recommends that you include the BY ACCESS clause for all AUDIT statements, which results in a more detailed audit record. If you specify neither clause, then BY SESSION is the default.

ITPub博客

Oracle 11G OCP 1Z0-052 39

最新文章