QUESTION: 9

The "sample" table consists of the following data:
How many rows are returned by executing the following SQL statement? SELECT DISTINCT ON (data) * FROM sample;

2 rows
3 rows
4 rows
5 rows
6 rows

Answer(s): B

Reveal Solution Next Question

QUESTION: 10

The following SQL statements were executed using psql.
Select the appropriate statement about the result.
LISTEN sign_v;
BEGIN;
NOTIFY sign_v;
COMMIT;
LISTEN sign_v;

At the point that 'NOTIFY sign_v' is executed, a message that starts with "Asynchronous
notification 'sign_v' received" is output.
At the point that 'COMMIT' is executed, a message that starts with "Asynchronous notification
'sign_v' received" is output.
At the point that 'SELECT * FROM pg_user;" is executed, a message that starts with
"Asynchronous notification 'sign_v' received" is output.
When 'LISTEN sign_v' is executed for the second time, a message that starts with
"Asynchronous notification 'sign_v' received" is output.
The message "Asynchronous notification 'sign_v' received" is not received while in this
connection.

Answer(s): B

Reveal Solution Next Question

QUESTION: 11

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

SELECT 'ABC' . 'abc';
SELECT cat('ABC', 'abc') FROM pg_operator;
SELECT 'ABC' + 'abc';
SELECT 'ABC' + 'abc' FROM pg_operator;
SELECT 'ABC' || 'abc';

Answer(s): E

Reveal Solution Next Question

QUESTION: 12

Select two correct descriptions about views.

A view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.
A view is a virtual table which does not exist.
A view is created to simplify complicated queries.
You can create a view with the same name as already existing tables.
A view only exists while the postmaster is running, and is deleted when the postmaster stops.

Answer(s): B,C

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 3)

QUESTION: 9

QUESTION: 10

QUESTION: 11

QUESTION: 12