PostgreSQL PGCES-02 Exam Actual Questions

Name: PostgreSQL CE 8 Silver
Brand: QA4Exam
SKU: PGCES-02
Price: 30 USD
Availability: InStock
Rating: 4.8 (680 reviews)

The questions for PGCES-02 were last updated on Oct 3, 2024.

Viewing page 1 out of 28 pages.
Viewing questions 1-5 out of 142 questions

Unlock Access to All 142 Questions & Answers

Question No. 1

Select two statements that the command below DOES NOT do.

Note: $ is the command prompt. $ pg_dump -b -F c b > d

ABacks up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

BBacks up the 'b' database to the 'd' file.

CBacks up large objects.

DBacks up the 'c' database to the 'd' file as the 'c' user.

ECreates a backup, which is restorable with the pg_restore command.

Show Answer

Correct Answer: A, D

Question No. 2

A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all 172.16.1.0/24 md5 When user foo connects to database bar from host IP address 172.16.1.2, I would like password verification to not be performed. Select one appropriate line for the new pg_hba.conf file.

AAdd 'host foo bar 172.16.1.2/32 trust' to the first row.

BAdd 'host bar foo 172.16.1.2/32 trust' to the first row.

CAdd 'host foo bar 172.16.1.2/32 trust' to the last row.

DAdd 'host bar foo 172.16.1.2/32 trust' to the last row.

EThe settings are fine as is.

Show Answer

Correct Answer: B

Question No. 3

Select two suitable statements regarding a postmaster process.

AA postmaster process waits for client connection requests.

BA postmaster process receives and processes database queries.

CA postmaster process creates a child process which processes the given queries.

DA postmaster process collects statistical information.

EA postmaster process is created for each client connection.

Show Answer

Correct Answer: A, C

Question No. 4

Select a correct SQL command to change existing user "george"'s password to "foobar".

AALTER USER george WITH PASSWORD 'foobar';

BALTER USER george CHANGE PASSWORD 'foobar';

CALTER USER george SET PASSWORD 'foobar';

DSET USER george PASSWORD TO 'foobar';

ESET USER george ALTER PASSWORD 'foobar';

Show Answer

Correct Answer: A

Question No. 5

psql generated the following error message: psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connections on port 5432? Select two reasons that are NOT the cause of this error.

AHost 'server.example.com' does not exist.

BThe PostgreSQL server is not running on 'server.example.com'.

CThe PostgreSQL server is not accepting TCP/IP connections on 'server.example.com'.

DThe PostgreSQL server is running on a port other than 5432 on 'server.example.com'.

EThe username and/or password are incorrect.

Show Answer

Correct Answer: A, E

Unlock All Questions for PostgreSQL PGCES-02 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 142 Questions & Answers