【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解 - 13

biotwang

【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