Oracle Advanced PL/SQL Developer Professional Guide

Practice exercise

1. Identify the correct statements about the working of Fine Grained Access Control:
   1. A table can have only one security policy.
   2. Different policies can be used to protect SELECT, INSERT, UPDATE, and DELETE statements on a table but not one.
   3. The policy function returns the predicate information as WHERE <Column> = <Value>.
   4. Once associated, the FGAC policy cannot be revoked from the table.
2. A security policy can be associated to group of objects by the DBA. State true or false.
   1. True
   2. False
3. Chose the correct statement about DBMS_RLS:
   1. DBMS_RLS is used only for Row Level Security policies.
   2. The package is owned by SYS.
   3. It can create/drop/refresh policies and create/drop policy groups.
   4. Using DBMS_RLS to set the policy degrades the application performance. ...