PostgreSQL_CE
PGCES-02 · Question #119
PGCES-02 Question #119: Real Exam Question with Answer & Explanation
The correct answer is B. VACUUM ANALYZE. See the full explanation below for the reasoning.
Question
Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.
Options
- AVACUUM
- BVACUUM ANALYZE
- CEXPLAIN
- DEXPLAIN ANALYZE
- ENOTIFY
Community Discussion
No community discussion yet for this question.