Practice EnterpriseDB 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 backups in custom compressed format?