Oracle Exam 1Z0-883 Topic 4 Question 4 Discussion

Actual exam question for Oracle's 1Z0-883 exam

Question #: 4
Topic #: 4

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?

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

B3; only the top-level statements are logged.

C111; top-level statements and all lower-level statements are logged.

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

Show Suggested Answer

Suggested Answer: B

http://dev.mysql.com/doc/mysql-security-excerpt/5.5/en/audit-log-plugin-loggingcontrol.html

by Portia at May 07, 2022, 02:34 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!