Bird
0
0

You want to reclaim disk space immediately after deleting many rows from a large table sales. Which command should you use?

hard📝 Application Q8 of 15
PostgreSQL - Transactions and Concurrency
You want to reclaim disk space immediately after deleting many rows from a large table sales. Which command should you use?
AREINDEX sales;
BVACUUM sales;
CANALYZE sales;
DVACUUM FULL sales;
Step-by-Step Solution
Solution:
  1. Step 1: Identify command that reclaims space immediately

    VACUUM FULL compacts the table and frees disk space immediately.
  2. Step 2: Compare with other commands

    Regular VACUUM delays space freeing, ANALYZE updates stats only, REINDEX rebuilds indexes.
  3. Final Answer:

    VACUUM FULL sales; -> Option D
  4. Quick Check:

    Immediate space reclaim = VACUUM FULL [OK]
Quick Trick: Use VACUUM FULL to reclaim space immediately [OK]
Common Mistakes:
  • Using regular VACUUM expecting immediate space freeing
  • Confusing ANALYZE with VACUUM
  • Thinking REINDEX frees disk space

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes