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

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL PGCES-02 Exam - Topic 1 Question 103 Discussion

Select the most suitable statement about the creation of a new database.
E) You can set the character encoding when creating a new database.
A) Only a PostgreSQL superuser is authorized to create a new database.
B) The target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.
C) Only one database can be used at the same time even if two or more databases are created.
D) Only the OS superuser (root) can create databases.

PostgreSQL PGCES-02 Exam - Topic 1 Question 103 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 103
Topic #: 1
[All PGCES-02 Questions]

Select the most suitable statement about the creation of a new database.

Show Suggested Answer Hide Answer
Suggested Answer: E

by Darell at Jun 27, 2026, 02:14 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Jerry
3 days ago
Surprised that people think only root can create databases!
upvoted 0 times
...
Glenna
8 days ago
I disagree with A, any user with the right privileges can create a database.
upvoted 0 times
...
Latonia
14 days ago
B is correct! PGDATA or -D is the way to go.
upvoted 0 times
...
Anna
19 days ago
E is a nice feature, love that you can set character encoding!
upvoted 0 times
...
Pamella
24 days ago
Surprised to see D listed, thought any user could create one.
upvoted 0 times
...
Sherron
29 days ago
Wait, C is totally wrong! You can connect to multiple databases at once.
upvoted 0 times
...
Bette
1 month ago
I disagree with A, regular users can create databases too.
upvoted 0 times
...
Odette
1 month ago
B is correct! You can specify the target directory.
upvoted 0 times
...
Edna
1 month ago
I vaguely remember that we can set character encoding when creating a database, which makes option E a strong candidate.
upvoted 0 times
...
Dahlia
2 months ago
I’m pretty sure that multiple databases can be created and accessed simultaneously, so option C doesn’t seem right.
upvoted 0 times
...
Joseph
2 months ago
I think option B sounds familiar because we discussed environment variables in class, but I can’t recall if PGDATA is the only way to specify the directory.
upvoted 0 times
...
Francine
2 months ago
I remember something about superuser privileges, but I’m not sure if it’s only PostgreSQL superusers or if regular users can create databases too.
upvoted 0 times
...

Save Cancel