QUESTION: 41

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

Usernames not registered in the operating system cannot be registered as PostgreSQL
users.
To create a new user for PostgreSQL, the "newuser" command is used.
PostgreSQL cannot be in a state where multiple users exist at the same time.
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.
To delete an existing user for PostgreSQL, "deleteuser" command is used.

Answer(s): D

Reveal Solution Next Question

QUESTION: 42

I would like to enable all users to SELECT the "item" table.
Select the most appropriate SQL statement from below.

GRANT public SELECT ON item;
GRANT SELECT ON item TO public;
REVOKE 'r' ON item TO public;
REVOKE READ ON item TO public;
REVOKE public SELECT ON item;

Answer(s): B

Reveal Solution Next Question

Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL.
local all all trust
host all all 192.168.1.0/24 reject
host all all 192.168.0.0/16 trust
Select a host IP address which is authorized to connect to this database via the network. Note: INET domain socket communication is available.

127.0.0.1
192.168.1.1
192.168.0.1
192.168.1.0
None can be connected.

Answer(s): C

Reveal Solution Next Question

QUESTION: 44

Select one correct command to shutdown the postmaster AFTER all the clients have disconnected.

pg_ctl stop
pg_ctl -m fast stop
pg_ctl -m immediate stop
pg_ctl -m wait stop
pg_ctl -s stop

Answer(s): A

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 12)

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44

PGCES-02 Discussions & Posts