EnterpriseDB PostgreSQL-Essentials Exam Questions Instant Access

Question 1

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed. You want to edit and rerun the previously executed query. Which command can be used to edit the query buffer?

C\e

Answer : C

Question 2

In PostgreSQL, which system catalog stores information about databases?

Apg_database

Bpg_class

Cpg_tables

Dinformation_schema.databases

Answer : A

Question 3

Which pg_dump option allows you to dump only the data without schema definitions?

A-d

B--data-only

C-D

D--no-schema

Answer : B

Question 4

Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?

Apg_log

Bpg_xlog

Cpg_wal

Dwal_files

Answer : C

Question 5

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

A\ds

B\dn

C\schemas

D\ls

Answer : B

Question 6

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

Apg_restart_conf()

Bpg_reload_conf()

Creload_configuration()

Dpg_refresh_conf()

Answer : B

Question 7

Which parameter specifies the number of connections reserved for superusers in PostgreSQL?

Areserved_connections

Bsuperuser_reserved_connections

Cadmin_connections

Dmax_superuser_connections

Answer : B

EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam Questions