PGCES-02 Exam Questions and Answers

QUESTION: 21

A table named "sample" is defined as below. Select two statements which will generate a
constraint error.
CREATE TABLE sample (
i INTEGER PRIMARY KEY,
j INTEGER,
CHECK ( i > 0 AND j < 0 )
);

INSERT INTO sample VALUES (1, 0);
INSERT INTO sample VALUES (2, -2);
INSERT INTO sample VALUES (3, NULL);
INSERT INTO sample VALUES (NULL, -4);
INSERT INTO sample VALUES (5, -5);

Answer(s): A,D

Reveal Solution Next Question

The following is the result of executing the createlang command which is installed with PostgreSQL.
$ createlang -U postgres --list mydb
Procedural Languages
Name | Trusted?
---------+----------
plpgsql | yes
Select two correct statements from below.

The procedural language plpgsql is installed in the database mydb using the above command.
The procedural language plpgsql can be used in the database mydb.
plpgsql is a trusted language, so it can execute the OS commands on the server side.
plpgsql is a trusted language, so it can read/write OS files on the server side.
plpgsql is a safe language with restricted operations.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 23

Given the following two table definitions, select one SQL statement which will cause an error. CREATE TABLE sample1 (id INTEGER, data TEXT);
CREATE TABLE sample2 (id INTEGER);

SELECT id AS data, data FROM sample1;
SELECT id, id FROM sample1;
SELECT s1.id, s2.id FROM sample1 AS s1, sample1 AS s2;
SELECT s1.id, s2.id FROM sample1 s1, sample2 s2;
SELECT s1.id, s2.data FROM sample1 s1, sample2 s2;

Answer(s): E

Reveal Solution Next Question

QUESTION: 24

Select two suitable statements regarding creating a new table.

There is no upper limit to the number of columns in a table.
A newly created table is empty and has 0 rows.
You can only use alphabetic characters for a table name.
The row name must be within 16 characters.
The SQL 'CREATE TABLE' statement is used to create a new table.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 25

The tables "t1" and "t2" are defined below.
The tables "t1" and "t2" have columns "id" which are type of INTEGER and column "name"s which are type of TEXT.
t1
t2
The following SQL command was executed. Select the number of rows in the result. SELECT * FROM t1 NATURAL FULL OUTER JOIN t2;

2 rows
3 rows
4 rows
5 rows
6 rows

Answer(s): D

Reveal Solution Next Question

Postgresql PGCES-02 Exam (page: 5)
Postgresql PGCES-02 CE 8 Silver
Updated on: 25-Dec-2025

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

QUESTION: 25

Postgresql PGCES-02 Exam (page: 5) Postgresql PGCES-02 CE 8 Silver Updated on: 25-Dec-2025

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

QUESTION: 25

Postgresql PGCES-02 Exam (page: 5)
Postgresql PGCES-02 CE 8 Silver
Updated on: 25-Dec-2025