重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 1z0-883 第七题 [打印本页]

作者: jikcheng 时间: 2014-12-24 10:31
标题: 1z0-883 第七题
Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query: Mysql> SELECT user, host, plugin FROM mysql.users;

ERROR 1146 (42S02): Table ‘mysql.users’ doesn’t exist

Which subset of event attributes would indicate this error in the audit.log file?
A. NAME=”Query” STATUS=”1146”
SQLTEXT=”select user,host from users”/>
B. NAME=”Error” STATUS=”1146”
SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>
C. NAME=”Query” STATUS=”1146”
SQLTEXT=” Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>
D. NAME=”Error” STATUS=”1146”
SQLTEXT=”select user,host from users”/>
E. NAME=”Error” STATUS=”0”
SQLTEXT=”Error 1146 (42S02): Table ‘mysql.users’ doesn’t exist”/>

[此贴子已经被作者于2014-12-24 10:32:06编辑过]

作者: jikcheng 时间: 2014-12-24 10:35
原文翻译：

考虑oracle 企业级审计插件。你检查用户执行了一下的操作： Mysql> SELECT user, host, plugin FROM mysql.users;ERROR 1146 (42S02): Table ‘mysql.users’ doesn’t exist

审计日志记录的是哪个条目。

[此贴子已经被作者于2014-12-24 10:35:51编辑过]

作者: jikcheng 时间: 2014-12-24 10:39
答案选C

开启oracle 审计，查看审计日志和C 选项一样。

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)