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

2 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

Ivory

2 days ago

A) shell> mysql < audit_log_filter_linux_install.sql

upvoted 0 times

...

Minna

6 days ago

C) mysql> INSTALL PLUGIN audit_log;

upvoted 0 times

...

Colby

1 months ago

A) shell> mysql < audit_log_filter_linux_install.sql

upvoted 0 times

...

Keneth

2 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

2 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

2 months ago

C) mysql> INSTALL PLUGIN audit_log;

upvoted 0 times

...

Lizbeth

2 months 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

25 days ago

I believe option A, shell> mysql < audit_log_filter_linux_install.sql, is the correct command.

upvoted 0 times

...

Denna

1 months ago

I'm not sure, but I think option B could be the right choice.

upvoted 0 times

...

Troy

1 months ago

I think it might be option D, INSTALL COMPONENT audit_log.

upvoted 0 times

...

Louvenia

2 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

...