support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  1. Home
  2. Exams
  3. Postgresql
  4. PGCES-02

Postgresql PGCES-02 Exam Actual Questions
PGCES-02 PostgreSQL CE 8 Silver (Page 5 )

Updated On: 15-Aug-2026
Page 5 of 30
PDF with 142 Questions

The table "custom" is defined below.
The "id" column and "introducer" column are of INTEGER type, and the "email" column is of TEXT type.

id | email | introducer
----+-----------------+------------
2 | aaa@example.com | 1
3 | bbb@example.com | 2
4 | ccc@example.com | 2
Three SQL statements were executed in the following order: INSERT INTO custom
SELECT max(id) + 1, 'ddd@example.com', 4 FROM custom;
UPDATE custom SET introducer = 999
WHERE email = 'bbb@example.com';
DELETE FROM custom
WHERE introducer NOT IN (SELECT id FROM custom);
Select the number of rows in the "custom" table after the execution.

  1. 0 rows
  2. 1 row
  3. 2 rows
  4. 3 rows
  5. 4 rows

Answer(s): C



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

  1. 0 rows
  2. 1 row
  3. 2 rows
  4. 3 rows
  5. 4 rows

Answer(s): C



Select an incorrect statement regarding the following SQL statement. Note that "user_view" is a
view.
CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;

  1. It is defining a rule "rule_1".
  2. It will replace "rule_1" if it already exists.
  3. Executing 'UPDATE user_view' will no longer output errors.
  4. When executing 'UPDATE user_view', data is updated in the table that is the origin of the
    view.
  5. 'DROP RULE rule_1 ON user_view' deletes the above definition.

Answer(s): D



The "animal" table consists of the following data:
Select the correct result returned by executing the following SQL statement:
SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;

  1. A syntax error will occur.

Answer(s): A



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.

  1. INSERT INTO foo VALUES ('12345');
  2. INSERT INTO foo VALUES ('5000000000');
  3. INSERT INTO foo VALUES ('ABC');
  4. INSERT INTO foo VALUES (2000000000);
  5. INSERT INTO foo VALUES (NULL);

Answer(s): B,D



  PDF
Viewing page 5 of 30
Viewing questions 21 - 25 out of 142 questions


Post your Comments and Discuss Postgresql PGCES-02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!

© 2026 Free-Braindumps.com - A Community of Learners.

Free-Braindumps.com is owned by Xùnliàn Limited, a company registered at 15 Wang Chiu Rd, Kowloon Bay, Hong Kong.

The resources, practice tests, and study guides on Free-Braindumps.com are strictly for educational and research purposes. We are an independent community platform and are not affiliated with, endorsed by, or sponsored by any official certification vendors, including Microsoft, Cisco, Amazon, CompTIA, or others. All certification names, trademarks, and logos are the property of their respective owners. Our content is user-contributed or independently developed to assist with exam preparation and skill assessment; we do not host or provide access to proprietary, confidential, or live exam questions.