nerdexam
Oracle

1Z0-116 · Question #54

Which two statements are true about Database Vault rules and rule sets?

The correct answer is C. If a rule set Is disabled. It Is evaluated to true without having Its rules evaluated. D. A given rule can be added to only one rule set. C is correct because Oracle Database Vault treats a disabled rule set as automatically evaluating to TRUE - it bypasses rule evaluation entirely and grants access. This is a deliberate design choice: disabling a rule set is meant to "open" it, not block it. D is correct because…

Using Oracle Database Vault

Question

Which two statements are true about Database Vault rules and rule sets?

Options

  • AYou must create a rule set for a rule, before creating the rule.
  • BYou con reference Oracle-supplied rules In rule sets that you create.
  • CIf a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.
  • DA given rule can be added to only one rule set.
  • EDeleting a rule set also deletes all the rules that have been added to It.

How the community answered

(19 responses)
  • B
    5% (1)
  • C
    95% (18)

Explanation

C is correct because Oracle Database Vault treats a disabled rule set as automatically evaluating to TRUE - it bypasses rule evaluation entirely and grants access. This is a deliberate design choice: disabling a rule set is meant to "open" it, not block it.

D is correct because rules in Database Vault are bound to a single rule set; you cannot share or reuse a rule across multiple rule sets. If you need the same logic in two rule sets, you must create separate rule objects.

Why the distractors are wrong:

  • A - Backwards. Rules and rule sets are created independently; you create a rule first, then add it to a rule set.
  • B - You cannot reference Oracle-supplied (internal) rules in custom rule sets; only user-defined rules are available for inclusion.
  • E - Deleting a rule set is non-cascading. The rules inside it remain as standalone objects in the database.

Memory tip: Think of a disabled rule set like an unlocked door - it defaults to open (TRUE) rather than closed. And think of rules like assigned employees - each belongs to one team (rule set), not shared across departments.

Topics

#Database Vault#Rules and Rule Sets#Access Control#Security Policies

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice