Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

PostgreSQL PGCES-02 Exam - Topic 8 Question 99 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 99
Topic #: 8

[All PGCES-02 Questions]

Select two suitable statements regarding the pg_dump command.

Apg_dump is an SQL command.

BOnly the user who executed initdb can execute pg_dump.

Cpg_dump can create a backup while postmaster is running.

Dpg_dump can create a backup while postmaster is stopped.

Epg_dump can create a backup of a specified table.

Show Suggested Answer

Suggested Answer: C, E

by Elvera at May 03, 2026, 07:13 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephanie

5 hours ago

Wait, is pg_dump really an SQL command? I thought it was a utility.

upvoted 0 times

...

Truman

5 days ago

Totally agree, it's super handy for live backups!

upvoted 0 times

...

Colene

11 days ago

pg_dump can create a backup while postmaster is running.

upvoted 0 times

...

Josefa

16 days ago

I’m confused about B; I thought anyone with the right permissions could run pg_dump, not just the initdb user.

upvoted 0 times

...

Kara

2 months ago

I practiced a question like this, and I believe pg_dump can back up specific tables, so E might be right.

upvoted 0 times

...

Cruz

2 months ago

I think pg_dump can work while the postmaster is running, but I'm not entirely sure about the specifics.

upvoted 0 times

...

Jin

2 months ago

I remember pg_dump is definitely not an SQL command, so A seems wrong.

upvoted 0 times

...