Oracle Exam 1Z0-908 Topic 5 Question 84 Discussion

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

Question #: 84
Topic #: 5

[All 1Z0-908 Questions]

Which command enables rule-based MySQL Auditing capabilities?

Ashell> mysql < audit_log_filter_linux_install.sql

Bshell> mysqld --initialize --log-raw=audit.log

Cmysql> INSTALL PLUGIN audit_log;

Dmysql> INSTALL COMPONENT audit_log;

Show Suggested Answer

Suggested Answer: A

by Jeanice at Jul 12, 2024, 04:06 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lillian

10 days ago

B sounds like it's trying to initialize the MySQL server, but that's not what we're looking for here. We need to enable the audit logging feature, not the entire server.

upvoted 0 times

...

Keneth

14 days ago

I'm not sure, but I think D) mysql> INSTALL COMPONENT audit_log; could also be a valid command for enabling rule-based MySQL Auditing.

upvoted 0 times

...

Vi

14 days ago

Haha, the answer is definitely not A. Trying to run a SQL script directly from the shell? That's like trying to hammer a nail with a screwdriver!

upvoted 0 times

...

Edison

17 days ago

I agree with Sheldon, installing the audit_log plugin seems like the right command for MySQL Auditing capabilities.

upvoted 0 times

...

Pearline

18 days ago

Option D seems more logical to me. The INSTALL COMPONENT command is specifically designed for enabling component-based features like audit logging.

upvoted 0 times

...

Willetta

20 days ago

I think option C is the correct answer. The INSTALL PLUGIN command is used to enable the audit logging feature in MySQL.

upvoted 0 times

Louvenia

7 days ago

I agree, option C is the correct answer.

upvoted 0 times

...

Sheldon

22 days ago

I think the answer is C) mysql> INSTALL PLUGIN audit_log;

upvoted 0 times

...