READ Free Dumps For Oracle- 1z0-062
Question ID 2485 | Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: |
Option A | A. All the triggers for the table are disabled without changing any of the column names or column types in the table. |
Option B | B. The primary key constraint on the EMPLOYEES table is disabled during redefinition. |
Option C | C. VPD policies are copied from the original table to the new table during online redefinition. |
Option D | D. You must copy the VPD policies manually from the original table to the new table during online redefinition. |
Correct Answer | B,C |
Question ID 2486 | Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? |
Option A | A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace. |
Option B | B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace. |
Option C | C. All the components may be moved into SYSAUX tablespace. |
Option D | D. All the components may be moved from the SYSAUX tablespace. |
Correct Answer | A,B |