PostgreSQL Exam PGCES-02 Topic 2 Question 66 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 66
Topic #: 2

Choose the most suitable statement about user management of PostgreSQL.

Note: the version of PostgreSQL is 8.0.

AUsernames not registered in the operating system cannot be registered as PostgreSQL users.

BTo create a new user for PostgreSQL, the 'newuser' command is used.

CPostgreSQL cannot be in a state where multiple users exist at the same time.

DIf you create a user that has permission to create other users, that user will become a superuser that is not subject to any access restriction checks.

ETo delete an existing user for PostgreSQL, 'deleteuser' command is used.

Show Suggested Answer

Suggested Answer: B

by Lavelle at Jul 06, 2024, 08:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Graham

2 days ago

Hmm, B sounds plausible, but I'm pretty sure PostgreSQL uses the 'createuser' command instead of 'newuser'. I'll keep that in mind.

upvoted 0 times

...

Ashleigh

9 days ago

Option D seems logical, but I'm not sure if that's the most suitable statement for PostgreSQL 8.0. I'll have to double-check the documentation.

upvoted 0 times

...

Caitlin

17 days ago

I'm not sure, but I think the answer might be B. To create a new user for PostgreSQL, the 'newuser' command is used.

upvoted 0 times

...

Margarett

18 days ago

I disagree, I believe the correct answer is D. If you create a user with permission to create other users, that user becomes a superuser.

upvoted 0 times

...

Jesusita

20 days ago

I think the answer is A, usernames not registered in the operating system cannot be registered as PostgreSQL users.

upvoted 0 times

...