Which statement about the ADMIN_MOVE_TABLE procedure is true?
A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operation to the target table.
B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-supplied staging table so they can be replayed against the target table when the move is complete.
C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, the target table is renamed (to the source table name) once the data has been copied into the target table.
D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table is to be created automatically, a name that is different from that of the active table must be specified for the target table.
|
Download Printable PDF. VALID exam to help you PASS. |
 |