Oracle
1Z0-883 · Question #65
1Z0-883 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
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?
Options
- 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.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.