EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials Exam Questions
QUESTION NO: 1
You need to reclaim storage occupied by dead tuples in the customers table. Which command should you use?
You need to reclaim storage occupied by dead tuples in the customers table. Which command should you use?
Correct Answer: B
QUESTION NO: 2
You want to view all available functions in the current database using psql. Which command should you use?
You want to view all available functions in the current database using psql. Which command should you use?
Correct Answer: C
QUESTION NO: 3
Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?
Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?
Correct Answer: C
QUESTION NO: 4
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?
Correct Answer: B
QUESTION NO: 5
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?
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: C
QUESTION NO: 6
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
Correct Answer: D
QUESTION NO: 7
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 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?
Correct Answer: A
QUESTION NO: 8
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
Correct Answer: B
QUESTION NO: 9
You want to set temporary memory to 8MB. Which parameter should you configure?
You want to set temporary memory to 8MB. Which parameter should you configure?
Correct Answer: B
