PostgreSQL_CE
PGCES-02 · Question #119
Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.
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
How the community answered
(66 responses)- A2% (1)
- B80% (53)
- C5% (3)
- D11% (7)
- E3% (2)
Community Discussion
No community discussion yet for this question.