Oracle OCP题库原创解析（54）

ITAA-OCM · 发表于 2012-3-16 15:47:23

You execute the following command to audit the database activities:

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

What is the effect of this command?

A) One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

B) One audit record is created for every session when any user successfully drops a table owned by SCOTT.

C) One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

D) One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

E) One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

Answer: A

BY SESSION: 表示同一个用户同一个会话中相同类型的SQL语句只审计一次。

WHENEVER SUCCESSFUL：只有当SQL语句执行成功时才审计。

彼岸：花已开 · 发表于 2012-3-16 15:50:27

{:soso_e129:}

lwhuang8 · 发表于 2012-6-9 06:12:36

顶你一下，好贴要顶！

jiazl88 · 发表于 2012-7-17 16:38:06

冰蓝静轩 · 发表于 2012-8-10 14:00:18

为了学习，努力赚钱。

再辛苦也值得。努力，加油

caidaoyiba · 发表于 2012-9-20 15:24:14

路过！！！
帮顶……

账号		自动登录	找回密码
密码			论坛注册

[题库] Oracle OCP题库原创解析（54）