EnterpriseDB PostgreSQL-Essentials Exam Questions Instant Access

Question 1

You want to export query results to a CSV file from psql. Which command should you use?

A\copy tablename TO 'filename.csv' CSV

BEXPORT TO 'filename.csv'

C\export filename.csv

DSAVE AS 'filename.csv'

Answer : A

Question 2

Which pg_dump option creates a backup that can be restored using pg_restore?

A-Fp (plain text format)

B-Fc (custom format)

C-Ft (tar format)

DBoth B and C

Answer : D

Question 3

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

Awal_level must be set to replica or higher

Bwal_archiving must be set to on

Carchive_level must be set to full

Dbackup_mode must be set to archive

Answer : A

Question 4

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

A\a

B\t

C\x

D\h

Answer : B

Question 5

Which configuration parameter controls the amount of memory allocated for shared buffers?

Abuffer_memory

Bshared_buffers

Ccache_size

Dmemory_buffers

Answer : B

Question 6

Which pg_restore option allows you to drop database objects before recreating them?

A-d

B-c or --clean

C-r

D--drop-all

Answer : B

Question 7

In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?

AALWAYS prevents manual value insertion, BY DEFAULT allows it

BThey are identical

CALWAYS uses UUID, BY DEFAULT uses serial

DBY DEFAULT prevents manual insertion

Answer : A

EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam Questions