PostgreSQL Exam PGCES-02 Topic 9 Question 56 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 56
Topic #: 9

[All PGCES-02 Questions]

Select the correct command to collect and save the statistical information of a table.

AANALYZE

BCLUSTER

CREINDEX

DSTATISTIC COLLECTION

ESTATISTIC COLLECTOR

Show Suggested Answer

Suggested Answer: A

by Harrison at Mar 11, 2024, 02:15 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

8 days ago

D) STATISTIC COLLECTION seems like the right choice. It's a more descriptive name for the command that does this job.

upvoted 0 times

...

14 days ago

I think the correct answer is A) ANALYZE. This command collects and saves the statistical information of a table.

upvoted 0 times

...

23 days ago

I'm not sure, but I think it might be D) STATISTIC COLLECTION because it sounds like it would collect statistics.

upvoted 0 times

...

24 days ago

I agree with Cecil, ANALYZE is used to collect and save statistical information of a table.

upvoted 0 times

...

25 days ago

I think the correct command is A) ANALYZE.

upvoted 0 times

...