MENU
Choose the most suitable statement about user management of PostgreSQL.
Note: the version of PostgreSQL is 8.0.
Suggested Answer: B
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
39 comments · newest first
LA
Lashon
10 months ago
E is wrong too, it's 'dropuser' for deleting users, not 'deleteuser'.
IV
Ivette
11 months ago
Wait, can you really have multiple users at the same time? C seems off.
PA
Pamella
11 months ago
B is incorrect, it's actually 'createuser' not 'newuser'.
CA
Camellia
11 months ago
I think D is misleading, superusers have more than just user creation rights.
LA
Laurel
11 months ago
A is definitely true, usernames need to be in the OS.
MA
Marjory
12 months ago
I’m a bit confused about option D; I thought having the ability to create users doesn't automatically make someone a superuser.
NO
Nobuko
12 months ago
I practiced a question similar to this, and I recall that PostgreSQL supports multiple users at once, so option C seems incorrect.
OD
Odette
12 months ago
I’m not entirely sure, but I think the command to create a user is actually 'CREATE USER', not 'newuser'. That makes me doubt option B.
GO
Golda
1 year ago
I remember reading that PostgreSQL users can be created independently of the operating system, so I think option A might be wrong.
MA
Marva
1 year ago
Option D about superusers seems concerning. I'll need to make sure I understand the access control implications for that type of user account in PostgreSQL 8.0.
NA
Natalya
1 year ago
The 'newuser' command in option B doesn't sound right to me. I think the actual command is 'createuser' for creating new PostgreSQL users.
MO
Mozell
1 year ago
Option A sounds plausible, as I recall that PostgreSQL users are typically mapped to operating system users. But I'll need to verify that for the 8.0 version.
SH
Shasta
1 year ago
Hmm, the question mentions PostgreSQL 8.0, which is an older version. I'll need to double-check my knowledge on the user management features in that specific release.
MA
Martina
1 year ago
I'm not too familiar with the specifics of PostgreSQL user management, so I'll need to read through the options carefully to see which one seems most accurate based on the version provided.
GE
Georgeanna
1 year ago
Hmm, I'm a bit unsure about this one. I know the custom configurations need to be in a specific location, but I can't quite remember if it's A or B. I'll have to think this through carefully.
CA
Casie
1 year ago
I'm feeling pretty confident about this one. The key is understanding how the stop-loss coverage works and calculating the hospital's responsibility based on the attachment point and percentage.
JE
Jenise
1 year ago
Hmm, I'm a bit unsure about this one. I know high availability is important, but I'm not totally clear on the specific reasons why the configurations need to match. I'll have to review my notes and try to reason through the options.
LU
Luisa
1 year ago
Okay, let me think this through. The question is asking about the purpose of simulation when planning a wireless network. I'll need to carefully consider the options to select the 3 correct answers.
LA
Lawrence
1 year ago
Wow, PostgreSQL 8.0? That's, like, ancient history. I bet the user management features have changed a lot since then. This question is a real throwback!
GR
Gracia
1 year ago
Wait, 'deleteuser'? Seriously? I thought it was 'dropuser' or something. Guess I need to brush up on my PostgreSQL user management commands.
SH
Sharee
1 year ago
D) If 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.
BE
Beth
1 year ago
B) To create a new user for PostgreSQL, the 'newuser' command is used.
NA
Natalya
1 year ago
A) Usernames not registered in the operating system cannot be registered as PostgreSQL users.
OL
Ollie
1 year ago
E has to be the right answer. 'deleteuser' is the command used to remove an existing PostgreSQL user. I've used that before.
LA
Larue
1 year ago
E) To delete an existing user for PostgreSQL, 'deleteuser' command is used.
RO
Ronnie
1 year ago
B) To create a new user for PostgreSQL, the 'newuser' command is used.
EL
Elena
1 year ago
A) Usernames not registered in the operating system cannot be registered as PostgreSQL users.
GI
Gilberto
1 year ago
C definitely can't be correct. PostgreSQL allows multiple users to exist simultaneously. That's kind of the whole point of a multi-user database, right?
GR
Graham
1 year ago
Hmm, B sounds plausible, but I'm pretty sure PostgreSQL uses the 'createuser' command instead of 'newuser'. I'll keep that in mind.
VA
Vanna
1 year ago
D) If 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.
LI
Linsey
1 year ago
C) PostgreSQL cannot be in a state where multiple users exist at the same time.
MA
Major
1 year ago
B) To create a new user for PostgreSQL, the 'createuser' command is used.
AI
Aileen
1 year ago
A) Usernames not registered in the operating system cannot be registered as PostgreSQL users.
AS
Ashleigh
1 year 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.
AP
Apolonia
1 year ago
Yes, it's important to double-check the documentation to be sure. But superusers do have a lot of control in PostgreSQL.
AL
Alease
1 year ago
I think option D is correct. Superusers in PostgreSQL have a lot of power.
CA
Caitlin
2 years 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.
MA
Margarett
2 years 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.
JE
Jesusita
2 years ago
I think the answer is A, usernames not registered in the operating system cannot be registered as PostgreSQL users.