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 types C. VPD policies are copied from the original table to the new table during online redefinition. The triggers cloned to the interim table are disabled until the redefinition is completed. Once the redefinition is complete, all cloned objects are renamed to the original names used by they objects they were cloned from.

New Features for Manageability

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 types
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 redefinition.

How the community answered

(55 responses)

A
85% (47)
B
11% (6)
D
4% (2)

Explanation

The triggers cloned to the interim table are disabled until the redefinition is completed. Once the redefinition is complete, all cloned objects are renamed to the original names used by they objects they were cloned from.

Topics

#online table redefinition#VPD policies#trigger behavior#DBMS_REDEFINITION

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice