PostgreSQL Exam PGCES-02 Topic 11 Question 26 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 26
Topic #: 11

Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.

AVACUUM

BVACUUM ANALYZE

CEXPLAIN

DEXPLAIN ANALYZE

ENOTIFY

Show Suggested Answer

Suggested Answer: A

by Theola at May 30, 2022, 09:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Melissa

2 days ago

NOTIFY? I'll just send a carrier pigeon to let the database know it's time for a cleanup.

upvoted 0 times

...

Daisy

3 days ago

EXPLAIN ANALYZE? I prefer to just 'explain' to my boss why the database is slow.

upvoted 0 times

...

Mignon

9 days ago

VACUUM ANALYZE? Gotta keep that database in tip-top shape, am I right?

upvoted 0 times

...

Lemuel

13 days ago

VACUUM? Sounds like I'm cleaning my room, not my database!

upvoted 0 times

...

Lilli

22 days ago

I'm not sure, but I think it might be B) VACUUM ANALYZE because it also updates statistics.

upvoted 0 times

...

Lynsey

24 days ago

I agree with Thomasena, VACUUM is used to reclaim space and update statistics.

upvoted 0 times

...

Thomasena

26 days ago

I think the correct answer is A) VACUUM.

upvoted 0 times

...