Oracle Exam 1Z0-116 Topic 3 Question 56 Discussion

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

Question #: 56
Topic #: 3

[All 1Z0-116 Questions]

Examine this list:

1. You must monitor access to email column or salary column In the employees table.

2. If any activity is detected, the action must be audited and a notification sent out by email.

3. The database has Unified Auditing enabled.

4. You have created and successfully tested the email sending procedure, sysadmin_fga.emaii._ai.ert.

You create the audit policy:

A user with select privilege on hr.employees executes this :

SELECT email FROM HR.EMPLOYEES;

What will be the result?

AThe query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

BThe query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent.

CThe query will be executed, but no audit entry will be created nor any mail sent.

DThe query will be executed, no audit entry will be created but the mall will be sent.

Show Suggested Answer

Suggested Answer: C

by Reuben at Sep 19, 2024, 08:15 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vanda

2 months ago

Wow, this is a real brainteaser. I'm going to have to go with A, but only because I've got a sixth sense for these things. Or maybe it's just a really good guess. Either way, I'm feeling lucky!

upvoted 0 times

Yan

1 months ago

User3: Yeah, that sounds right. A seems like the best choice.

upvoted 0 times

...

Abel

1 months ago

I agree, it makes sense that the query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

upvoted 0 times

...

Tegan

1 months ago

I think the correct answer is A.

upvoted 0 times

...

Elenore

2 months ago

This question is like a riddle wrapped in an enigma. I'm going to go with C just to see what happens. Better to be a hacker than a quacker, am I right? *wink wink*

upvoted 0 times

Graciela

2 months ago

Yeah, C sounds like the right choice.

upvoted 0 times

...

Golda

2 months ago

I agree, let's go with C.

upvoted 0 times

...

Floyd

2 months ago

I think the answer is C.

upvoted 0 times

...

I'm not sure about this one. If the FGA_LOG$ table is the one being used for auditing, then I'd say the answer is B. But the question mentions Unified Auditing, so A might be the correct answer. Man, these certification exams can be tricky!

upvoted 0 times

...

Christiane

2 months ago

I think the correct answer is A. The question states that the database has Unified Auditing enabled, and the audit policy is set up to monitor access to the email column. So, the query should be audited, and a notification should be sent out.

upvoted 0 times

Lacresha

1 months ago

Definitely, it helps ensure data security and compliance with regulations.

upvoted 0 times

...

Leanora

1 months ago

That makes sense. It's important to have proper auditing in place for sensitive data like email addresses.

upvoted 0 times

...

Rashad

1 months ago

Yes, I agree. The query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

upvoted 0 times

...

Ryan

1 months ago

upvoted 0 times

...

Joni

3 months ago

I'm not sure, but I think option A makes sense because the query will be executed and an entry will be created in the unified audit trail.

upvoted 0 times

...

Kaitlyn

3 months ago

I agree with Alesia, option A seems to be the most logical choice.

upvoted 0 times

...

Alesia

3 months ago

I think the correct answer is A.

upvoted 0 times

...

Oracle Exam 1Z0-116 Topic 3 Question 56 Discussion

Contribute your Thoughts:

Vanda

Yan

Abel

Tegan

Elenore

Graciela

Golda

Floyd

Delpha

Christiane

Lacresha

Leanora

Rashad

Ryan

Joni

Kaitlyn

Alesia