Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?

The correct answer is A. All the triggers for the table are disabled without changing any of the column names or column C. VPD policies are copied from the original table to the new table during online redefinition. 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…

Managing Schema Objects

Question

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

Exhibit

Options

AAll the triggers for the table are disabled without changing any of the column names or column
BThe primary key constraint on the EMPLOYEES table is disabled during redefinition.
CVPD policies are copied from the original table to the new table during online redefinition.
DYou must copy the VPD policies manually from the original table to the new table during online

How the community answered

(49 responses)

A
92% (45)
B
2% (1)
D
6% (3)

Explanation

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).

Topics

#online table redefinition#VPD policies#table triggers#schema objects

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice