MENU
Which command reclaims all obsolete row space and compacts the customers table for reuse?
Suggested Answer: B
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
LA
Lai
3 months ago
But what about A) VACUUM customers? It also reclaims space, just not as thoroughly.
SH
Sherman
3 months ago
I agree, B is the best choice. It reclaims space effectively.
RE
Refugia
3 months ago
I think it's B) VACUUM FULL customers. It really compacts the table.
CA
Catherin
3 months ago
I agree with B, it’s the most thorough option!
BE
Bettyann
3 months ago
Wait, does VACUUM FULL really reclaim all space? Sounds too good to be true!
NI
Nichelle
4 months ago
VACUUM FULL is the one that compacts, right?
MI
Mickie
5 months ago
I thought it was A) VACUUM customers?
WI
Willow
5 months ago
Definitely B) VACUUM FULL customers;
MI
Michal
6 months ago
CLUSTER customers sounds familiar, but I can't recall if it does the same thing as VACUUM FULL.
MO
Moon
6 months ago
I feel like ANALYZE customers is related to statistics, not reclaiming space.
AH
Ahmad
6 months ago
I remember practicing a similar question, and I think VACUUM is just for cleaning up space, not compacting.
GE
Gerald
6 months ago
I think it's B) VACUUM FULL customers, but I'm not entirely sure if it also compacts the table.