PrepAway - Latest Free Exam Questions & Answers

Which statement about the ADMIN_MOVE_TABLE procedure is…

Which statement about the ADMIN_MOVE_TABLE procedure is true?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply