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

Katina

6 months ago

I agree with Claire, C seems like the most logical option.

upvoted 0 times

...

Cyndy

6 months ago

I think the answer is C because it mentions using CATAS for CBT.

upvoted 0 times

...

Ciara

6 months ago

I disagree, I believe it is A because it only reclaims space from deleted rows.

upvoted 0 times

...

Joni

6 months ago

I think the answer is D because it says it reclaims space and re-orders data.

upvoted 0 times

...

Lashaun

6 months ago

I think the answer B) Enough space is required for GROOM to make a complete copy of the table actually makes sense.

upvoted 0 times

...

Domitila

7 months ago

I'm not sure, but I think answer A) It reclaims space from deleted rows and does not re-order data could be right.

upvoted 0 times

...

Pamella

7 months ago

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

upvoted 0 times

...

Shenika

7 months ago

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

upvoted 0 times

...

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

8 months ago

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

upvoted 0 times

Vi

7 months ago

Yeah, definitely overkill to make a complete copy of the table.

upvoted 0 times

...

Whitley

7 months ago

A) It reclaims space from deleted rows and does not re-order data.

upvoted 0 times

...

Eugene

8 months 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

8 months 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

8 months 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

8 months 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

...

IBM Exam C1000-085 Topic 2 Question 55 Discussion

Contribute your Thoughts:

Katina

Cyndy

Ciara

Joni

Lashaun

Domitila

Pamella

Shenika

Ettie

Latonia

Vi

Whitley

Eugene

Milly

Elza

Anastacia