Free EnterpriseDB PostgreSQL-Essentials-v13 Exam Questions

Become EnterpriseDB Certified with updated PostgreSQL-Essentials-v13 exam questions and correct answers

Page: 1 / 24

Total 117 Questions | Updated On: Aug 20, 2026

Add To Cart

Question 1

You want to set the maximum time to complete client authentication to 10 seconds. Which parameter should you configure?

A : authentication_timeout = 10s

B : auth_timeout = 10s

C : client_timeout = 10s

D : connection_timeout = 10s

Answer: A

Question 2

You need to restore a database from a compressed format backup file created with pg_dump -Fc option. Which utility should you use?

A : psql

B : pg_restore

C : pg_dump

D : pg_basebackup

Answer: B

Question 3

In PostgreSQL, what does VACUUM do?

A : Compresses the database

B : Reclaims storage occupied by dead tuples

C : Creates database backups

D : Optimizes query execution plans

Answer: B

Question 4

You are writing an initialization script to help your team in creating a new database cluster. You want toensure that a new database cluster is initialized with md5 as the default authentication method. Which of thefollowing options of the initdb command can be used to specify the default authentication method?

A : -U

B : -authenticate

C : -A

D : -db-auth

Answer: C

Question 5

Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?

A : pg_dump

B : pg_dumpall

C : pg_backup

D : pg_clusterbackup

Answer: B

Page: 1 / 24

Total 117 Questions | Updated On: Aug 20, 2026

Add To Cart