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.

4. Identify the correct statements about the context of an application:

   1. A user who holds the CREATE CONTEXT privilege can create a context.

   2. It is owned by the user SYS.

   3. A user can check context metadata in USER_CONTEXTS.

   4. The trusted package...