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: Apr 27, 2026

Add To Cart

Question 1

You want to set temporary memory to 8MB. Which parameter should you configure?

A : temp_memory = 8MB

B : work_mem = 8MB

C : temp_buffers = 8MB

D : temporary_memory = 8MB

Answer: C

Question 2

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 3

While connected to a PostgreSQL database using psql, you want to toggle the timing information of some queries. Which of the following options can be used to achieve this?

A : \time on

B : \timing

C : \time off

D : \t

Answer: B

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

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

Page: 1 / 24

Total 117 Questions | Updated On: Apr 27, 2026

Add To Cart