Discuss PostgreSQL PGCES-02 Exam Topic 1 Question 103

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

AOnly a PostgreSQL superuser is authorized to create a new database.

BThe target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.

COnly one database can be used at the same time even if two or more databases are created.

DOnly the OS superuser (root) can create databases.

EYou can set the character encoding when creating a new database.

Suggested Answer: E

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

21 comments · newest first

Almeta 2 days ago

E is a good choice too. Setting encoding helps with multi-language support.

Colette 7 days ago

A is too restrictive. Many users can create databases with the right permissions.

Sue 12 days ago

Definitely B. Without specifying the directory, it won't work.

Izetta 17 days ago

I feel like E is also important. Character encoding matters for data integrity.

Bette 22 days ago

Option A is misleading. Superuser isn't the only one who can create databases.

Emmanuel 28 days ago

I agree, B makes the most sense. Environment variables are key.

Pearlie 1 month ago

I think option B is correct. PGDATA is crucial for database creation.

Cyril 1 month ago

C seems off, multiple databases can be accessed at once.

Lashanda 1 month ago

E is a good point, character encoding is important!

Jerry 2 months ago

Surprised that people think only root can create databases!

Glenna 2 months ago

I disagree with A, any user with the right privileges can create a database.

Latonia 2 months ago

B is correct! PGDATA or -D is the way to go.

Anna 2 months ago

E is a nice feature, love that you can set character encoding!

Pamella 2 months ago

Surprised to see D listed, thought any user could create one.

Sherron 2 months ago

Wait, C is totally wrong! You can connect to multiple databases at once.

Bette 3 months ago

I disagree with A, regular users can create databases too.

Odette 3 months ago

B is correct! You can specify the target directory.

Edna 3 months ago

I vaguely remember that we can set character encoding when creating a database, which makes option E a strong candidate.

Dahlia 3 months ago

I’m pretty sure that multiple databases can be created and accessed simultaneously, so option C doesn’t seem right.

Joseph 3 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.

Francine 4 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.

PostgreSQL PGCES-02 Exam - Topic 1 Question 103 Discussion