Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Lillian
1 months 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
Colby
14 days ago
A) shell> mysql < audit_log_filter_linux_install.sql
upvoted 0 times
...
...
Keneth
1 months 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
1 months 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
Nikita
26 days ago
C) mysql> INSTALL PLUGIN audit_log;
upvoted 0 times
...
Lizbeth
29 days ago
A) shell> mysql < audit_log_filter_linux_install.sql
upvoted 0 times
...
...
Edison
2 months ago
I agree with Sheldon, installing the audit_log plugin seems like the right command for MySQL Auditing capabilities.
upvoted 0 times
...
Pearline
2 months 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
2 months 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
Na
5 days ago
I believe option A, shell> mysql < audit_log_filter_linux_install.sql, is the correct command.
upvoted 0 times
...
Denna
13 days ago
I'm not sure, but I think option B could be the right choice.
upvoted 0 times
...
Troy
16 days ago
I think it might be option D, INSTALL COMPONENT audit_log.
upvoted 0 times
...
Louvenia
1 months ago
I agree, option C is the correct answer.
upvoted 0 times
...
...
Sheldon
2 months ago
I think the answer is C) mysql> INSTALL PLUGIN audit_log;
upvoted 0 times
...

Save Cancel