PrepAway - Latest Free Exam Questions & Answers

What is the effect of enabling compression and then run…

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply