nerdexam
PostgreSQL_CE

PGCES-02 · Question #110

Choose the most suitable statement about user management of PostgreSQL. Note: the version of PostgreSQL is 8.0.

The correct answer is D. If you create a user that has permission to create other users, that user will become a. See the full explanation below for the reasoning.

Question

Choose the most suitable statement about user management of PostgreSQL. Note: the version of PostgreSQL is 8.0.

Options

  • 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
  • ETo delete an existing user for PostgreSQL, "deleteuser" command is used.

How the community answered

(23 responses)
  • A
    4% (1)
  • C
    4% (1)
  • D
    83% (19)
  • E
    9% (2)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice