nerdexam
Oracle

1Z0-043 · Question #163

You want to enforce a company's business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the…

The correct answer is C. DBMS_RLS.SHARED_STATIC E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE. See the full explanation below for the reasoning.

Question

You want to enforce a company's business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

Options

  • ADBMS_RLS.STATIC
  • BDBMS_RLS.DYNAMIC
  • CDBMS_RLS.SHARED_STATIC
  • DDBMS_RLS.CONTEXT_SENSITIVE
  • EDBMS_RLS.SHARED_CONTEXT_SENSITIVE

How the community answered

(46 responses)
  • A
    4% (2)
  • B
    11% (5)
  • C
    83% (38)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice