Câu 34: C2090-611: DB2 10.1 DBA for Linux UNIX and Windows

Which statement about the ADMIN_MOVE_TABLE procedure is true?

1. 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.
2. 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.
3. 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. — đáp án hiện tại
4. 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.