POSTGRESQL ESSENTIALS.pdf
Q: 1
You want to export the emp table to a CSV file with column headers using the COPY command.
Which command should you use?
Options
Q: 2
Which PostgreSQL backup utility can create backups in custom compressed format?
Options
Q: 3
Which configuration parameter controls the amount of memory allocated for shared buffers?
Options
Q: 4
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED
BY DEFAULT AS IDENTITY?
Options
Q: 5
Which parameter must be set to enable WAL archiving for Point-in-Time Recovery in PostgreSQL 13?
Options
Q: 6
Which pg_dump option creates a backup that can be restored using pg_restore?
Options
Q: 7
You need to configure your server to accept TCP/IP connections from specific IP addresses. Which file
should you modify?
Options
Q: 8
What is the purpose of shared_buffers configuration parameter in PostgreSQL?
Options
Q: 9
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
Options
Q: 10
You want to create a backup of all databases in a PostgreSQL cluster. Which utility should you use?
Options
Question 1 of 10
