PostgreSQL Exam PGCES-02 Topic 3 Question 52 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 52
Topic #: 3

Based on the following request, select the most appropriate command for creating a database cluster. ?Character encoding of the template database needs to be EUC_JP ?Locale is not used

Ainitdb --locale=EUC_JP --no-encoding

Binitdb --default-encoding=EUC_JP

Cpg_ctl init --locale=EUC_JP

Dinitdb --encoding=EUC_JP --no-locale

Epg_ctl init --encoding=EUC_JP

Show Suggested Answer

Suggested Answer: A, D

by Rodolfo at Dec 09, 2023, 10:57 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Yuette

5 days ago

Hmm, option D does seem like the right choice. I wonder if the exam creators are testing our knowledge of PostgreSQL configuration options. This is a pretty specific question!

upvoted 0 times

...

Loren

7 days ago

Hmm, I see your point. Let's discuss it further to figure out the best option for the exam.

upvoted 0 times

...

Thad

8 days ago

I disagree, I believe the correct answer is E) pg_ctl init --encoding=EUC_JP

upvoted 0 times

...

Loren

10 days ago

I think the answer is D) initdb --encoding=EUC_JP --no-locale

upvoted 0 times

...

Margret

13 days ago

I think option D is the most appropriate command since it specifies the encoding as EUC_JP and also includes the '--no-locale' option to indicate that locale is not used.

upvoted 0 times

...