IBM
C2090-600 · Question #29
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…
The correct answer is D. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG. See the full explanation below for the reasoning.
Question
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?
Options
- AAll data, both new and existing, will be compressed.
- BOnly new or updated data for XML columns will be compressed.
- CNew and existing XML columns will be compressed but other columns remain unchanged.
- DExisting data will remain uncompressed because the RESETDICTIONARY option of the REORG
How the community answered
(33 responses)- A9% (3)
- B3% (1)
- C6% (2)
- D82% (27)
Community Discussion
No community discussion yet for this question.