PrepAway - Latest Free Exam Questions & Answers

Which statement about the ADMIN_MOVE_TABLE procedure is true?

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 operationto 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-suppliedstaging 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, thetarget 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 isto be created automatically, a name
that is different from that of the active table must be specified for the target table.


Leave a Reply