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.
Explanation:
C (not D): CONS_VPD_AUTO
Used to indicate to copy VPD policies automatically
* DBMS_RLS.ADD_POLICY
/ The DBMS_RLS package contains the fine-grained access control administrative interface, which
is used to implement Virtual Private Database (VPD).DBMS_RLS is available with the Enterprise
Edition only.
Note:
* CONS_USE_PK and CONS_USE_ROWID are constants used as input to the “options_flag”
parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure.
CONS_USE_ROWID is used to indicate that the redefinition should be done using rowids while
CONS_USE_PK implies that the redefinition should be done using primary keys or pseudoprimary keys (which are unique keys with all component columns having NOT NULL constraints).
* DBMS_REDEFINITION.START_REDEF_TABLE
To achieve online redefinition, incrementally maintainable local materialized views are used.
These logs keep track of the changes to the master tables and are used by the materialized viewsduring refresh synchronization.
* START_REDEF_TABLE Procedure
Prior to calling this procedure, you must manually create an empty interim table (in the same
schema as the table to be redefined) with the desired attributes of the post-redefinition table, and
then call this procedure to initiate the redefinition.
B and C
A C.
B seems incorrect because PK is used with redefinition option CONS_USE_PK
this question was poorly prepared (for sure). “A” is better suited with respect to the provisional table. The “D” opposes with the response “C”. “B” is wrong, Then, “A” and “C” are more likely
Neither constraints nor triggers are disabled. Test scripts are at http://orabase.org/index.php/exam-prepare/1z0-060-prepare/1z0-060-prepare-q2/ (Authors misinterpreted results, as they didn’t check triggers status before redefinition). So it seems to me that this is a problem question.
A,C
In addition, until the redefinition process is either completed or aborted, any trigger defined on the interim table does not execute.
A,C is correct answer
http://www.aiotestking.com/oracle/which-two-statements-are-true-about-redefining-the-table/
A C
options_flag => DBMS_REDEFINITION.CONS_USE_PK implies that the redefinition should be done using primary keys or pseudo- primary keys
AC