Free PGCES-02 Exam Braindumps
PGCES-02 PostgreSQL CE 8 Silver Questions 6–10 (page: 3)

The table "score" is defined as follows:

gid | score
-----+-------
1 | 70
1 | 60
2 | 100
3 | 80
3 | 50
The following query was executed. Select the number of rows in the result. SELECT gid, max(score) FROM score
GROUP BY gid HAVING max(score) > 60;

Table "t1" is defined as follows:
CREATE TABLE t1 (value VARCHAR(5));
A set of SQL statements were executed in the following order. Select the number of rows that
table "t1" has after execution.
BEGIN;
INSERT INTO t1 VALUES ('AA');
SAVEPOINT point1;
INSERT INTO t1 VALUES ('BB');
SAVEPOINT point2;
INSERT INTO t1 VALUES ('CC');
ROLLBACK TO point1;
INSERT INTO t1 VALUES ('DD');
END;

Select two suitable statements about sequences.

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;

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;