EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials FREE EXAM DUMPS QUESTIONS & ANSWERS
In PostgreSQL, which view provides information about currently running queries?
Correct Answer: B
Vote an answer
You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?
Correct Answer: A
Vote an answer
Which parameter sets the number of autovacuum worker processes?
Correct Answer: B
Vote an answer
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?
Correct Answer: A
Vote an answer
Which pg_dump option creates a backup that can be restored using pg_restore?
Correct Answer: D
Vote an answer
Which command in psql toggles between aligned and unaligned output mode?
Correct Answer: A
Vote an answer
You want to set the effective cache size for indexes to 512MB. Which parameter should you configure?
Correct Answer: A
Vote an answer
You want to list all available databases in your PostgreSQL cluster using psql. Which command should you use?
Correct Answer: D
Vote an answer
In PostgreSQL, archiving can be enabled for hot backups. During recovery, all the archive logs can be played on the restored backup and Point-in-Time Recovery can be performed. Which of the following parameters directly influences Mean Time to Recovery and is also used to control the size of the WAL area?
Correct Answer: A
Vote an answer