Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

205

积分

19

好友

29

主题
发表于 2016-7-20 11:49:10 | 查看: 669| 回复: 0
【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解

13.

Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db() has 10 auditable statements.
You run the following statements in the mydb database:
  1. mysql> CALL prepare_db();
  2. mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
  3. mysql> SHOW TABLES;
复制代码
How many events are added to the audit log as a result of the preceding statements?


A. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.
B. 3; only the top-level statements are logged.
C. 111; top-level statements and all lower-level statements are logged.
D. 12; only top-level statements and stored procedure events are logged.
----------------------------------------

答案:B

分析:
audit.log文件中每个<AUDIT_RECORD>元素代表了一个事件,如客户连接或关闭连接事件,执行SQL语句等。
仅顶层语句会被记录下来,存储程序(如触发器或存储过程)中的语句不会被记录。
命令如LOAD DATA INFILE在进行操作时,其对文件内容进行进行操作的具体细节不会被记录。
因此,A, C, D错,B正确。

参考:
http://dev.mysql.com/doc/refman/ ... ogging-control.html
您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-9-26 00:45 , Processed in 0.061177 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569