Free 1Z0-060 Exam Braindumps


Which two statements are true about redefining the table?

A. Al 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 manual y from the original table to the new table during
online redefinition.

Answer(s): BC
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
pseudo-primary keys (which are unique keys with all component columns having NOT NULL
constraints).
* DBMS_REDEFINITION.START_REDEF_TABLE


3