Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table? (Choose two.)
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.
Suggested Answer:BC🗳️
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 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 views during 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.
Answer: AC
https://docs.oracle.com/database/121/ARPLS/d_redefi.htm#ARPLS67515
A. All the triggers of this tables will be disables
B. Primary key of this tables will not be disabled.
The triggers of interim table stays disabled while redifinition in progress, not triggers of table being redefined. Nothing is said in document about table triggers being disabled. :
All cloned referential constraints involving the interim tables will be created disabled (they will be automatically enabled after the redefinition) and all triggers on interim tables will not fire till the redefinition is completed. After the redefinition is complete, the cloned objects will be renamed to the corresponding pre-redefinition names of the objects (from which they were cloned from).
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
sherifelia
Highly Voted 5 years agokhan
Highly Voted 5 years, 8 months agoRay520
2 years, 8 months ago