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?
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |