Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-600 All Questions

View all questions & answers for the C2090-600 exam
Go to Exam

Exam C2090-600 topic 1 question 7 discussion

Actual exam question from IBM's C2090-600
Question #: 7
Topic #: 1
[All C2090-600 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by db2tester at Oct. 9, 2019, 2:49 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
db2tester
5 years, 1 month ago
The correct answer is A. Existing data is compressed. New data will be compressed. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel