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
  2. Home
  3. Exams
  4. Postgresql
  5. PGCES-02

Postgresql PGCES-02 Exam
PGCES-02 PostgreSQL CE 8 Silver (Page 2 )

Updated On: 12-Jan-2026
Page 2 of 30
PDF with 142 Questions

Select two suitable statements regarding the following SQL statement:
CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

  1. It is defining a trigger "trigger_1".
  2. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
  3. The "write_log" function is called before 'UPDATE' takes place.
  4. 'UPDATE' is not executed if "write_log" returns NULL.
  5. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.

Answer(s): A,E



A set of tables are defined as follows:
t1
t2
How many rows are returned by executing the following SQL statement?
SELECT * FROM t1
WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id);

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

Answer(s): B



The table "foo" is defined as follows:
CREATE TABLE foo (bar TEXT);
Next, four SQL statements were executed in the following order. INSERT INTO foo VALUES ('bar'); -------- (1)
ALTER TABLE foo ADD COLUMN c1 TEXT; ---- (2)
ALTER TABLE foo ADD UNIQUE (c1); ------- (3)
ALTER TABLE foo DROP COLUMN bar; ------- (4)
Select the correct statement from those below.

  1. An error occurs when executing the (1) SQL statement.
  2. An error occurs when executing the (2) SQL statement.
  3. An error occurs when executing the (3) SQL statement.
  4. An error occurs when executing the (4) SQL statement.
  5. No error is generated.

Answer(s): E



From the SQL commands below, select one that is generally classified as "DDL".

  1. START TRANSACTION
  2. CREATE TABLE
  3. SELECT
  4. INSERT
  5. DELETE

Answer(s): B



The following question concerns the use of multibyte characters in PostgreSQL.
Select two correct items about character encoding in PostgreSQL.

  1. "./configure --enable-multibyte" must be designated at time of build.
  2. When the database cluster is initialized, the or --multibyte option must be specified.
  3. Character encoding can be set on a per database basis.
  4. Only a single character encoding can be specified for each database cluster.
  5. Different character encodings can be specified for server and clients.

Answer(s): C,E



Viewing page 2 of 30
Viewing questions 6 - 10 out of 142 questions



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

Join the PGCES-02 Discussion