ExamQuestions.com

Register
Login
Upgrade to Oracle Database 12c Exam Questions

Oracle

Upgrade to Oracle Database 12c

2 / 125

Question 2:

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

Answer options:

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.