Oracle Exam 1Z0-116 Topic 2 Question 52 Discussion

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

Question #: 52
Topic #: 2

Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.

Examine these requirements:

1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.

2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.

3. Audit records are to be collected for every evaluation of the rule set.

Which two options are true when creating the rule set?

AOne rule set contains two rules OR'ed together.

BThe rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

CThe rule set must be defined as is_static.

DThe rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

EThe rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

Show Suggested Answer

Suggested Answer: B

by Gail at Aug 03, 2024, 06:13 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Holley

1 months ago

You know, I'm just happy I don't have to worry about configuring Database Vault in my day-to-day job. Sounds like a real headache! At least we have these practice questions to keep us on our toes.

upvoted 0 times

Azalee

10 days ago

B) The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

upvoted 0 times

...

Shawn

18 days ago

A) One rule set contains two rules OR'ed together.

upvoted 0 times

...

Rosio

1 months ago

Wait, wait, hold up. I'm pretty sure we need two separate rules OR'ed together for the different access levels. A seems like the obvious choice here. What are you guys, database ninjas or something?

upvoted 0 times

Fausto

4 days ago

B) The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

upvoted 0 times

...

Bernardo

20 days ago

A) One rule set contains two rules OR'ed together.

upvoted 0 times

...

Stephen

2 months ago

Ah, I see. The rule set needs to be static to ensure consistent enforcement, and the audit options need to capture both failures and successes. Looks like E is the way to go.

upvoted 0 times

Edison

1 months ago

Absolutely, E is the way to go to ensure comprehensive audit records for every evaluation of the rule set.

upvoted 0 times

...

Aliza

2 months ago

Yes, you're right. E is the correct option for capturing both failures and successes in the audit records.

upvoted 0 times

...

Rebbeca

2 months ago

Hmm, you might be right. But I still think option D is also true as it mentions eval_options parameter.

upvoted 0 times

...

Trina

2 months ago

Hmm, I think B and D are the correct options here. It makes sense to audit the rule set's failure and evaluate all rules to meet the requirements.

upvoted 0 times

Erick

30 days ago

Yes, auditing the rule set's failure and evaluating all rules are crucial for meeting the requirements.

upvoted 0 times

...

Donte

1 months ago

That's true, we need to ensure all rules are evaluated to enforce security properly.

upvoted 0 times

...

Dalene

2 months ago

I think option D is also important to evaluate all rules for the hr.employees table.

upvoted 0 times

...

Maynard

2 months ago

I agree, option B is necessary for auditing the rule set's failure.

upvoted 0 times

...

Robt

2 months ago

I disagree, I believe option B is correct because it talks about setting audit_options parameter to dbms_macutl.g_ruleset_audit_fail.

upvoted 0 times

...

Rebbeca

3 months ago

I think option A is true because it mentions having two rules in one rule set.

upvoted 0 times

...