Name: PostgreSQL PGCES-02 Exam
Brand: Pass4Success
SKU: PGCES-02
Price: 69.00 USD
Availability: InStock
Rating: 4.7 (165 reviews)

Disscuss PostgreSQL PGCES-02 Topics, Questions or Ask Anything Related

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Free PostgreSQL PGCES-02 Exam Actual Questions

The questions for PGCES-02 were last updated On May. 07, 2024

Question #1

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.

Reveal Solution

Correct Answer: A, C

Question #2

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.

Reveal Solution

Correct Answer: A, E

Question #3

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.

Reveal Solution

Correct Answer: B

Question #4

Select two correct statements from below concerning the ANALYZE command.

AIt renews the statistical information of the table content.

BIt takes some time to execute, but it does not lock the table.

CIf the FULL option is used when executing, the size of the file can be reduced.

DIf ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

EIf ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.

Reveal Solution

Correct Answer: A, D

Question #5

Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.

A'PREPARE'/'EXECUTE' is mainly used to optimize performance.

B'PREPARE' creates a plan for the prepared statement.

C'PREPARE' can only specify 'SELECT' as a prepared statement.

D'EXECUTE' executes the plan defined by 'PREPARE'.

E'DEALLOCATE' deallocates prepared statements.

Reveal Solution

Correct Answer: C

Unlock all PGCES-02 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now