Free PGCES-02 Exam Braindumps
PGCES-02 PostgreSQL CE 8 Silver Questions 56–60 (page: 13)

There is a table "tb1" that has a column "c1" defined as type TEXT. The following SQL is executed while client "A" is connected.
BEGIN;
LOCK TABLE tb1 IN ACCESS EXCLUSIVE MODE; SELECT * FROM tb1;
While the above 'SELECT' statement is being executed, client "B" connects to the same database and executes the following SQL.
Select two correct statements describing the behavior of PostgreSQL.
INSERT INTO tb1 (c1) VALUES ('new line');
Note: the default transaction isolation level is set to "read committed".

The "sample" table consists of the following data.
How many rows are returned by executing the following SQL statement?
SELECT i FROM sample GROUP BY i;

The tables "t1" and "t2" are defined below.
Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type.
t1
t2
The following SQL command was executed. Select the number of rows in the result. SELECT * FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;

Select the SQL command that must be executed prior to executing the EXECUTE command.

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