EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam Questions

Page: 1 / 14
Total 71 questions
Question 1

Which parameter must be set to enable WAL archiving for Point-in-Time Recovery in PostgreSQL 13?



Answer : B


Question 2

Which parameter sets the number of autovacuum worker processes?



Answer : B


Question 3

You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?



Answer : B


Question 4

You want to reload the PostgreSQL configuration without restarting the server. Which function should you execute?



Answer : B


Question 5

Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?



Answer : B


Question 6

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



Answer : B


Question 7

You want to list all schemas in the current database using psql. Which command should you use?



Answer : B


Page:    1 / 14   
Total 71 questions