IBM Exam C1000-085 Topic 10 Question 76 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 76
Topic #: 10

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 Erasmo at Jan 15, 2025, 01:36 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

Hmm, I'm not sure about that. I thought GROOM just reclaimed space, but didn't re-order the data. Oh well, guess I need to review my notes again.

upvoted 0 times

...

6 days ago

I agree with Mozelle. GROOM is designed to optimize the storage and performance of a CBT by removing deleted rows and reorganizing the data.

upvoted 0 times

...

7 days ago

Option D is the correct answer. GROOM reclaims space from deleted rows and re-orders the data for a Clustered Base Table (CBT).

upvoted 0 times

1 days ago

Option D is correct. GROOM reclaims space from deleted rows and re-orders data.

upvoted 0 times

...