Examine the following commands for redefining a table with Virtual Private Database (VPD)
policies: Which two statements are true about redefining the table?
A.
All the triggers for the table are disabled without changing any of the column names or
column types in the table.
B.
The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C.
VPD policies are copied from the original table to the new table during online redefinition.
D.
You must copy the VPD policies manually from the original table to the new table during
online redefinition.
Correct:
A.
All the triggers for the table are disabled without changing any of the column names or column types in the table.
C.
VPD policies are copied from the original table to the new table during online redefinition.
BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => ‘hr’,
object_name => ’employees’,
policy_name => ’employees_policy’,
function_schema => ‘hr’,
policy_function => ‘auth_emp_dep_100’,
statement_types => ‘select, insert, update, delete’
);
END;
/
In this example, the hr.employees table is redefined to disable all of its triggers. No column names or column types are changed during redefinition.
DBMS_REDEFINITION.CONS_VPD_AUTO
Specify this value to copy the VPD policies automatically from the original table to the new table during online redefinition.