Free PostgreSQL-Essentials Exam Braindumps
PostgreSQL Essentials Certification v13 Questions 16–20 (page: 5)

Updated On: 10-Feb-2026

Which of the following commands in psql will execute SQL commands from a file?

  1. \i filename
  2. \e filename
  3. \f filename
  4. \x filename

Answer(s): A



In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?

  1. wal_level must be set to replica or higher
  2. wal_archiving must be set to on
  3. archive_level must be set to full
  4. backup_mode must be set to archive

Answer(s): A



Which psql command displays the command history?

  1. \h
  2. \s
  3. \history
  4. \log

Answer(s): B



You want to create a backup of all databases in a PostgreSQL cluster.
Which utility should you use?

  1. pg_dump
  2. pg_dumpall
  3. pg_backup
  4. pg_clusterbackup

Answer(s): B



Which configuration file controls client authentication in PostgreSQL?

  1. postgresql.conf
  2. pg_hba.conf
  3. pg_ident.conf
  4. auth.conf

Answer(s): B



Viewing page 5 of 16
Viewing questions 21 - 25 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!