Free Practice Questions for EnterpriseDB PostgreSQL-Essentials Exam

Question 1

You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?

ACOPY emp TO '/path/emp.csv' WITH CSV;

BCOPY emp TO '/path/emp.csv' WITH CSV HEADER;

CCOPY emp TO '/path/emp.csv' DELIMITER ',' HEADER;

DEXPORT emp TO '/path/emp.csv' CSV HEADER;

Correct Answer: B. COPY emp TO '/path/emp.csv' WITH CSV HEADER;

Question 2

You want to execute SQL commands from a file using psql. Which command should you use?

A\e filename

B\i filename

C\f filename

D\run filename

Correct Answer: B. \i filename

Question 3

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

Apg_kill_backend(pid)

Bpg_terminate_backend(pid)

Cpg_cancel_backend(pid)

Dpg_disconnect_backend(pid)

Correct Answer: B. pg_terminate_backend(pid)

Question 4

Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?

Awork_mem

Bshared_buffers

Cmaintenance_work_mem

Dautovacuum_work_mem

Correct Answer: C. maintenance_work_mem

Question 5

Which psql command toggles the display of tuples only (without column headers)?

A\a

B\t

C\x

D\h

Correct Answer: B. \t

Question 6

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

Apg_dump with -Fc option

Bpg_restore

Cpg_basebackup

Dpsql

Correct Answer: A. pg_dump with -Fc option

Question 7

What is the purpose of shared_buffers configuration parameter in PostgreSQL?

ATo set the amount of memory for sorting

BTo determine memory for caching data from disk

CTo control WAL buffer size

DTo set connection pool size

Correct Answer: B. To determine memory for caching data from disk

Question 8

Which psql command quits the psql interface?

A\exit

B\quit

C\q

DAll of the above

Correct Answer: D. All of the above

Question 9

You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?

Apg_restart_conf()

Bpg_reload_conf()

Creload_configuration()

Drefresh_config()

Correct Answer: B. pg_reload_conf()

Question 10

Which command rebuilds an index that is performing slowly for better performance?

AREBUILD INDEX indexname;

BREINDEX INDEX indexname;

CVACUUM INDEX indexname;

DANALYZE INDEX indexname;

Correct Answer: B. REINDEX INDEX indexname;