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?

Question

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?

Accepted Answer

B. 3; only the top-level statements are logged.

Answer

A. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.

Answer

C. 111; top-level statements and all lower-level statements are logged.

Answer

D. 12; only top-level statements and stored procedure events are logged.

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…

Question

Options

How the community answered

Community Discussion