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?

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.)

A.
DBMS_RLS.STATIC

B.
DBMS_RLS.DYNAMIC

C.
DBMS_RLS.SHARED_STATIC

D.
DBMS_RLS.CONTEXT_SENSITIVE

E.
DBMS_RLS.SHARED_CONTEXT_SENSITIVE

Explanation:

DBMS_RLS. SHARED_STATIC
The policy function executes once, Once , then the predicate is cached in the SGA, and it’s
Shared Across Multiple Objects, like Hosting environments, such as data warehouses where the
same predicate must be applied to multiple database objects DBMS_RLS.
SHARED_CONTEXT_SENSITIVE
The policy function executes first time and the object is reference in a database session
Predicates are cached in the private session memory UGA so policy functions can be shared
among objects.
REF.: Oracle(r) Database Security Guide 10g Release 2 (10.2) – p 15-30