EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam 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?

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?

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?

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

you use?

Which PostgreSQL backup utility can create backupsin custom compressed format?