Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. EnterpriseDB
  5. PostgreSQL-Essentials

EnterpriseDB PostgreSQL-Essentials Exam
PostgreSQL Essentials Certification v13 (Page 2 )

Updated On: 7-Feb-2026
Page 2 of 16
PDF with 71 Questions

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed. You want to edit and rerun the previously executed query.
Which command can be used to edit the query buffer?

  1. L
  2. R
  3. \e
  4. e

Answer(s): C



You are working as a Postgres DBA. Due to an increase in transactional load on your Postgres instance, the server is experiencing frequent checkpoints. You have decided to increase the WAL area size. You have also decided to upgrade your database instance to PostgreSQL 13.
While initializing your database cluster in PostgreSQL 13, you have decided to increase the WAL segment size.
Which of the following options can be used with the initdb command to set a custom WAL segment size?

  1. =- waldir
  2. --wal-segsize
  3. -x
  4. No such option is available in PostgreSQL

Answer(s): B



SERIAL and IDENTITY columns can be used to add an auto-incrementing column in a Postgres table.
Which of these two column types are SQL standard compliant?

  1. Serial
  2. Identity
  3. None

Answer(s): B



You want to list all available databases in your PostgreSQL cluster using psql.
Which command should you use?

  1. \list
  2. \l
  3. SHOW DATABASES;
  4. SELECT databases();

Answer(s): B



Which PostgreSQL backup utility can create backups in custom compressed format?

  1. pg_dump with -Fc option
  2. pg_restore
  3. pg_basebackup
  4. psql

Answer(s): A






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

Join the PostgreSQL-Essentials Discussion