Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

IBM C1000-085 Exam - Topic 6 Question 79 Discussion

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?
A) It reclaims space from deleted rows and does not re-order data
B) Enough space is required for GROOM to make a complete copy of the table
C) GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.
D) It reclaims space from deleted rows and re-orders data.

IBM C1000-085 Exam - Topic 6 Question 79 Discussion

Actual exam question for IBM's C1000-085 exam
Question #: 79
Topic #: 6
[All C1000-085 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A

by Marnie at Mar 03, 2025, 09:45 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Olive
6 months ago
C is interesting, but I don't think that's how it works.
upvoted 0 times
...
Lavina
6 months ago
D sounds right, it does both!
upvoted 0 times
...
Arminda
7 months ago
Wait, does GROOM really not re-order data?
upvoted 0 times
...
Leonora
7 months ago
I think B is misleading, not always true.
upvoted 0 times
...
Lavina
7 months ago
A is correct, it just reclaims space.
upvoted 0 times
...
Pete
7 months ago
I'm pretty confident that GROOM reclaims space and re-orders data, so I might lean towards option D.
upvoted 0 times
...
Yesenia
7 months ago
I feel like option C is related to how GROOM works, but I can't recall if it actually uses CATAS for CBT.
upvoted 0 times
...
Bettye
8 months ago
I remember a practice question about GROOM, and I think it mentioned needing enough space for a complete copy of the table.
upvoted 0 times
...
Lisha
8 months ago
I think the GROM command is supposed to reclaim space, but I'm not sure if it also re-orders the data.
upvoted 0 times
...
Justine
8 months ago
Ah, I see now. The GROM command uses CREATE TABLE AS SELECT (CATAS) to reclaim space and re-order the data on a CBT. Option C looks like the correct answer.
upvoted 0 times
...
Cheryll
8 months ago
Wait, I'm not sure about that. I thought the GROM command did re-order the data on a CBT. Let me double-check the details on that.
upvoted 0 times
...
Casie
8 months ago
Okay, I think I've got this. The GROM command reclaims space from deleted rows, but it doesn't re-order the data. That's option A, right?
upvoted 0 times
...
Caprice
8 months ago
Hmm, I'm a bit confused about the difference between reclaiming space and re-ordering data. I'll need to review my notes on the GROM command to make sure I pick the right answer.
upvoted 0 times
...
Pamella
8 months ago
This question seems straightforward, but I want to make sure I understand the key details about the GROM command and how it behaves on a Clustered Base Table (CBT).
upvoted 0 times
...

Save Cancel