Name: PostgreSQL PGCES-02 Exam
Brand: Pass4Success
SKU: PGCES-02
Price: 69.00 USD
Availability: InStock
Rating: 5.0 (188 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 Apr. 11, 2024

Question #1

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 #2

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

Question #3

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';

Reveal Solution

Correct Answer: A

Question #4

Select two SQL statements which abort a transaction.

AEND

BROLLBACK

CTRUNCATE

DABORT

EDROP TRANSTACTION

Reveal Solution

Correct Answer: B, D

Question #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.

Reveal Solution

Correct Answer: A, E

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