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

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

Free PGCES-02 Exam Braindumps (page: 5)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20