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 Feb 19, 2025.

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

Get All 142 Questions & Answers

Question No. 1

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

I would like to be able to save log entries as shown below. Select a correct configuration setting from statements below. LOG: connection received: host=[local] port= LOG: connection authorized: user=postgres database=test

Asyslog = true

Blog_connections = true

Clog_authorization = true

Dlog_hostname = true

Elog_min_level = log

Show Answer

Correct Answer: B

Question No. 4

The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT * FROM sample WHERE v ~ 'ab';

A0 rows

B1 row

C2 rows

D3 rows

E4 rows

Show Answer

Correct Answer: C

Question No. 5

The table "score" is defined as follows:

gid | score

-----+-------

1 | 70 1 |

60 2 | 100

3 | 80 3 |

The following query was executed. Select the number of rows in the result.

SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;

A1 row

B2 rows

C3 rows

D4 rows

E5 rows

Show Answer

Correct Answer: C

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