Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 40 of 132
Free Preview · 132 of 440 · questions 1–132 of 440 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- VACUUM removes old data files that are no longer referenced by the current table state and are older than the retention period (default 7 days). This helps manage storage costs but means those file versions can no longer be accessed via time travel. VACUUM does not optimize layout (OPTIMIZE does) or repair tables.