Postgresql PGCES-02 Exam Questions in PDF and Online

QUESTION: 16

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.

0 rows
1 row
2 rows
3 rows
4 rows

Answer(s): C

Reveal Solution Next Question

QUESTION: 17

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

0 rows
1 row
2 rows
3 rows
4 rows

Answer(s): C

Reveal Solution Next Question

QUESTION: 18

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;

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

Answer(s): D

Reveal Solution Next Question

QUESTION: 19

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;

A syntax error will occur.

Answer(s): A

Reveal Solution Next Question

QUESTION: 20

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.

INSERT INTO foo VALUES ('12345');
INSERT INTO foo VALUES ('5000000000');
INSERT INTO foo VALUES ('ABC');
INSERT INTO foo VALUES (2000000000);
INSERT INTO foo VALUES (NULL);

Answer(s): B,D

Reveal Solution Next Question

Postgresql PGCES-02 CE 8 Silver PGCES-02 Exam Questions in PDF

Free Postgresql PGCES-02 Dumps Questions (page: 4)

QUESTION: 16

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20