What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
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 becompressed.
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.
Answer: A
Latest C2090-600 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments