DB2 10 for z/OS Database Administrator — Question 41

Which statement about the db2move command is TRUE?

Answer options

• A. The LOAD actions can be run from a client machine.
• B. Object ownership cannot be changed after a successful schema copy operation.
• C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
• D. Loading data into tables containing XML columns is only supported for the LOAD actions.

Correct answer: D

Explanation

The correct answer is D, as loading data into tables with XML columns is limited to LOAD actions in db2move. Option A is incorrect because LOAD actions must typically be performed on the database server. Option B is false since object ownership can be changed after schema operations, and Option C is misleading as GENERATED ALWAYS identity columns can be managed, but certain constraints might apply.