IBM Exam C1000-085 Topic 8 Question 73 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 73
Topic #: 8

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

AIt reclaims space from deleted rows and does not re-order data

BEnough space is required for GROOM to make a complete copy of the table

CGROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

DIt reclaims space from deleted rows and re-orders data.

Show Suggested Answer

Suggested Answer: A

by Sharmaine at Oct 24, 2024, 02:03 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

8 days ago

Option B seems a bit off. Requiring enough space for a complete table copy seems like overkill for a GROOM operation.

upvoted 0 times

...

11 days ago

I disagree, I believe the correct answer is A) It reclaims space from deleted rows and does not re-order data.

upvoted 0 times

...

13 days ago

Hold up, did they really mean to say 'GROM' instead of 'GROOM'? That's a weird typo if so. Anyway, I'd go with option D.

upvoted 0 times

...

15 days ago

I disagree. Option C sounds like the right answer to me. CATAS is definitely involved in the GROOM process for CBTs.

upvoted 0 times

...

20 days ago

I think option D is correct. Reclaiming space from deleted rows and re-ordering data seems like the expected behavior for the GROM command on a CBT.

upvoted 0 times

...

20 days ago

I think the answer is D) It reclaims space from deleted rows and re-orders data.

upvoted 0 times

...