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:
Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE ‘/tmp/data.cav’ INTO TABLE mytable;
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