Post-Upgrade Tasks: Statistics Quiz Home › PostgreSQL DBA › Post-Upgrade Tasks: Statistics ✅ Postgres Database Administration – Post-Upgrade Tasks: Statistics 20 questions · 15 min timer · Explanations included · Free 1. Which of the following is a primary reason for running VACUUM after a PostgreSQL upgrade? To reclaim disk space from deleted rows To update system catalogs To rebuild indexes To reset transaction IDs None 1 out of 20 2. What is the effect of running VACUUM FULL on a PostgreSQL database? It locks the tables and reclaims space by rewriting the entire table. It updates the statistics for the query planner. It only removes dead tuples without locking the tables. It rebuilds all indexes in the database. None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!
