1Z0-116 · Question #30
Which three are true concerning command rules?
The correct answer is A. System privileges override command rules. D. For DML statement command rules, you can specify a wildcard for the object owner. F. For DML statement command rules, you can specify a wildcard for the object name.. A is correct because system-level privileges (e.g., SYSDBA, DBA role) sit above the command rule layer in Oracle Database Vault's enforcement hierarchy - privileged accounts bypass command rule restrictions. D and F are correct because DML command rules support wildcards (%) for
Question
Which three are true concerning command rules?
Options
- ASystem privileges override command rules.
- BIf a command rule's associated rule set evaluation results In an error, the command is not allowed
- CA command can have only one command rule that applies to it.
- DFor DML statement command rules, you can specify a wildcard for the object owner.
- EIf a command rule's associated rule set Is disabled, then the rule set evaluates to true.
- FFor DML statement command rules, you can specify a wildcard for the object name.
- GObject privileges override command rules.
How the community answered
(28 responses)- A75% (21)
- B14% (4)
- E7% (2)
- G4% (1)
Explanation
A is correct because system-level privileges (e.g., SYSDBA, DBA role) sit above the command rule layer in Oracle Database Vault's enforcement hierarchy - privileged accounts bypass command rule restrictions. D and F are correct because DML command rules support wildcards (%) for both the object owner and the object name, letting a single rule cover DML operations across all schemas or all tables without creating individual rules for each.
The distractors fail as follows: B is wrong - a rule set evaluation error causes the command to be allowed (fail-open), not blocked. C is wrong - multiple command rules can apply to the same command simultaneously. E is wrong - a disabled rule set evaluates to false, blocking the command, not true. G is wrong - object-level privileges (SELECT, INSERT, etc.) do not override command rules; only system privileges do (the distinction tested by A vs. G).
Memory tip: For DML rules, "both the Owner and the Name take wildcards" (D and F). For privileges, remember the hierarchy: System beats command rules, Object does not - system is top-tier, object is not.
Topics
Community Discussion
No community discussion yet for this question.