Free PostgreSQL-Essentials Exam Braindumps
PostgreSQL Essentials Certification v13 Questions 21–25 (page: 6)

Updated On: 10-Feb-2026

In PostgreSQL, what does VACUUM do?

  1. Compresses the database
  2. Reclaims storage occupied by dead tuples
  3. Creates database backups
  4. Optimizes query execution plans

Answer(s): B



Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?

  1. work_mem
  2. shared_buffers
  3. maintenance_work_mem
  4. autovacuum_work_mem

Answer(s): C



You want to view all available functions in the current database using psql.
Which command should you use?

  1. \df
  2. \f
  3. \functions
  4. \fn

Answer(s): A



Which pg_restore option allows you to drop database objects before recreating them?

  1. -d
  2. -c or --clean
  3. -r
  4. --drop-all

Answer(s): B



In PostgreSQL, which view provides information about currently running queries?

  1. pg_stat_activity
  2. pg_current_queries
  3. pg_running_queries
  4. pg_active_sessions

Answer(s): A



Viewing page 6 of 16
Viewing questions 26 - 30 out of 71 questions


Post your Comments and Discuss EnterpriseDB PostgreSQL-Essentials exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!