Adding the FULL option reclaims unused space in the entire database.
Adding the VERBOSE option allows you to obtain detailed information about the VACUUM process.
Adding the AUTO option performs VACUUM using the autovacuum settings.
Adding the ANALYZE option also updates statistics.
You can specify multiple tables in a single VACUUM command.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/29
A. Adding the FULL option performs a complete VACUUM, returning unused space to the operating system. This does not mean it processes the entire database. If a target table is not specified for the VACUUM command, the entire database is processed.
B. Adding the VERBOSE option outputs detailed information about the progress of the VACUUM process.
C. There is no AUTO option.
D. Adding the ANALYZE option updates statistics after the VACUUM process.
E. Only one table can be specified in a single VACUUM command.
Therefore, the correct answers are B and D.