IBM Exam C1000-085 Topic 2 Question 55 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 55
Topic #: 2

[All C1000-085 Questions]

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 Tamar at Apr 12, 2024, 04:00 AM

Limited Time Offer

25%

Off

Get Premium C1000-085 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ettie

1 days ago

All right, let's look at option C. That one's a bit tricky, but I think it's saying that GROOM uses CATAS to reclaim space and re-order the data, which is different from how it works for regular tables.

upvoted 0 times

...

Latonia

3 days ago

Haha, yeah, that would be like hiring a moving company to move your stuff across the street. Totally overkill.

upvoted 0 times

...

Eugene

4 days ago

Yeah, I agree. And option B is definitely not correct - GROOM doesn't need to make a complete copy of the table, that would be crazy!

upvoted 0 times

...

Milly

5 days ago

Okay, let's start with option A. That one seems pretty straightforward - GROOM does reclaim space from deleted rows, but it doesn't re-order the data. That makes sense to me.

upvoted 0 times

...

Elza

7 days ago

I know, right? But I think the key here is understanding how GROOM works specifically for CBTs. Let's go through the options and see what we can figure out.

upvoted 0 times

...

Anastacia

9 days ago

Ugh, I hate questions like this! GROOM is such a tricky topic, and they always try to catch us with these subtle differences between regular tables and CBTs.

upvoted 0 times

...