Most Recent PostgreSQL PGCES-02 Exam Dumps

Prepare for the PostgreSQL CE 8 Silver exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the PostgreSQL PGCES-02 exam and achieve success.

The questions for PGCES-02 were last updated on Apr 22, 2026.

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

Get All 142 Questions & Answers

Question No. 1

I would like to copy a database cluster directory for backup.

Select two incorrect statements from below.

AThe directory must be copied after stopping the database server.

BWhen using the Tablespace function, it is necessary to back up the directory that stores the tablespace as well.

CA database cluster that has been restored can be used on a separate machine with the same structure.

DA database cluster that has been restored can be used on a newer version of PostgreSQL.

EA database cluster that has been restored can be used on an older version of PostgreSQL.

Show Answer

Correct Answer: D, E

Question No. 2

Select two appropriate statements from below about the following SQL statements:

CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS '

DECLARE x ALIAS FOR $1; r text := ''default''; BEGIN IF x > 100 THEN SELECT INTO r data FROM mytable WHERE id = x; END IF; RETURN r; END;';

AAn error is generated unless the plpgsql language is registered in the database beforehand.

BThe execution results of SELECT myfunc(-123) differs based on the content of 'mytable'.

CWhen SELECT myfunc(123) is executed an error occurs.

DWhen SELECT myfunc(NULL) is executed an error occurs.

EWhen SELECT myfunc (0) is executed the text 'default' is returned.

Show Answer

Correct Answer: A, E

Question No. 3

Which psql command do you need to execute to display the list of tables in the currently connected database?

ASELECT * FROM pg_table_list;

BSHOW tables;

C\dT

D\dt 'database_name'

E\dt

Show Answer

Correct Answer: E

Question No. 4

Four SQL statements were executed in the following order.

CREATE TABLE foo (bar INT); ALTER TABLE foo ALTER bar

TYPE BIGINT; ALTER TABLE foo ADD baz VARCHAR(5);

ALTER TABLE foo DROP bar; Select two SQL statements that generate an error when executed.

AINSERT INTO foo VALUES ('12345');

BINSERT INTO foo VALUES ('5000000000');

CINSERT INTO foo VALUES ('ABC');

DINSERT INTO foo VALUES (2000000000);

EINSERT INTO foo VALUES (NULL);

Show Answer

Correct Answer: B, D

Question No. 5

Select the most suitable statement regarding PostgreSQL's pg_hba.conf configuration file.

AYou can use any number of authentication types on a single line.

BYou cannot set different authentications per user.

CYou can set different authentications per table.

DThe authentication settings in the file are evaluated from the top line to the bottom line.

Ekrb5 authentication can only be used for local connections.

Show Answer

Correct Answer: D

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