PostgreSQL Essentials Certification v13 (PostgreSQL-Essentials) Free Practice Test

Question 1

You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?

A. -d directory

B. -D directory

C. -o directory

D. --output directory

Correct Answer: B

Question 2

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

A. pg_reload_conf()

B. reload_configuration()

C. pg_restart_conf()

D. pg_refresh_conf()

Correct Answer: A

Question 3

Which psql command displays the command history?

A. \history

B. \h

C. \log

D. \s

Correct Answer: D

Question 4

Which psql meta-command displays the structure of a specific table including columns, types, and constraints?

A. SHOW TABLE tablename;

B. \dt tablename

C. \d tablename

D. DESCRIBE tablename;

Correct Answer: C

Question 5

Which PostgreSQL backup utility can create backups in custom compressed format?

A. pg_restore

B. pg_basebackup

C. pg_dump with -Fc option

D. psql

Correct Answer: C

Question 6

You are working as a Postgres DBA. You want to configure logging for slow running queries on your database cluster. Which setting needs to be modified to log all the queries which take more than 5 seconds?

A. log_destination

B. log_min_duration_statement

C. log_statement

D. log_duration

Correct Answer: B

Question 7

In PostgreSQL, which view provides information about currently running queries?

A. pg_active_sessions

B. pg_stat_activity

C. pg_running_queries

D. pg_current_queries

Correct Answer: B

Question 8

You want to allow up to 200 connected users in your PostgreSQL cluster. Which parameter should you modify in postgresql.conf?

A. max_clients = 200

B. connection_limit = 200

C. max_users = 200

D. max_connections = 200

Correct Answer: D

Question 9

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

A. pg_dump

B. pg_backup

C. pg_clusterbackup

D. pg_dumpall

Correct Answer: D

Welcome to TestSimulate

EnterpriseDB PostgreSQL Essentials Certification v13 (PostgreSQL-Essentials) Free Practice Test