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: Jun 16, 2026

Add To Cart

Question 1

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 2

Which psql meta-command is used to describe a table including its structure, columns, and constraints?

A : \dt tablename

B : \d tablename

C : \describe tablename

D : \show tablename

Answer: B

Question 3

Which command in psql toggles between aligned and unaligned output mode?

A : \a

B : \t

C : \align

D : \format

Answer: A

Question 4

You want to gracefully terminate a user's connection to the database. Which function should you use?

A : pg_kill_backend(pid)

B : pg_terminate_backend(pid)

C : pg_cancel_backend(pid)

D : pg_disconnect_backend(pid)

Answer: B

Question 5

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

Page: 1 / 24

Total 117 Questions | Updated On: Jun 16, 2026

Add To Cart