Postgresql PGCES-02 Exam Questions in PDF and Online

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

Table "t1" is defined below.
Table "t1" has a column "id" of type INTEGER, and a column "name" of type TEXT.
t1:
The following SQL is executed while client "A" is connected. BEGIN;
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
SELECT * FROM t1 WHERE id = 1 FOR UPDATE; -- (*)
While the second 'SELECT' statement, shown with (*), is being executed, a separate client "B" connects and executes the following SQL.
Select the correct statement about the execution results.
UPDATE t1 SET name = 'turtle' WHERE id = 2;
Note: the default transaction isolation level is set to "read committed".

The update process for client "B" is blocked until the current connection for client "A" is
finished.
The update process for client "B" is blocked until the current transaction for client "A" is
finished.
The 'UPDATE' process for client "B" proceeds regardless of the condition of client "A".
The process of client "B" immediately generates an error.
The processes for both clients are blocked, and an error stating that a deadlock has been
detected is generated.

Answer(s): B

Reveal Solution Next Question

QUESTION: 14

SQL statements were executed in the following order:
CREATE TABLE fmaster
(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ftrans
(id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE);
INSERT INTO fmaster VALUES (1, 'itemA');
INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
Select two SQL statements that will generate an error when executed next.

INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
INSERT INTO ftrans VALUES (2, 1, '2007-07-07');
UPDATE fmaster SET name = 'itemAX' WHERE id = 1;
UPDATE fmaster SET id = 100 WHERE id = 1;
UPDATE ftrans SET id = 200 WHERE id = 1;

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 15

Select three SQL statements which return NULL.

SELECT 0 = NULL;
SELECT NULL != NULL;
SELECT NULL IS NULL;
SELECT NULL;
SELECT 'null'::TEXT;

Answer(s): A,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: 3)

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15