DB2 10 for z/OS Database Administrator — Question 4

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

Answer options

• A. All data, both new and existing, will be compressed.
• B. Only new or updated data for XML columns will be compressed.
• C. New and existing XML columns will be compressed but other columns remain unchanged.
• D. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

Correct answer: D

Explanation

The correct answer is D because without using the RESETDICTIONARY option, existing data will not be compressed and will remain as it is. Options A, B, and C are incorrect because they imply that existing data would be compressed, which is not the case when the RESETDICTIONARY option is absent.