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

Stephen

12 days 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

...

Rebbeca

16 days 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

19 days 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

Maynard

3 days ago

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

upvoted 0 times

...

Robt

22 days 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

26 days ago

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

upvoted 0 times

...