Free PGCES-02 Practice Test (Page 3 ) & Exam Questions

QUESTION: 6

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;

1 row
2 rows
3 rows
4 rows
5 rows

Answer(s): C

Show Answer Next Question

QUESTION: 7

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;

1 row
2 rows
3 rows
4 rows
0 rows

Answer(s): B

Show Answer Next Question

QUESTION: 8

Select two suitable statements about sequences.

A sequence always returns a 4-byte INTEGER type value, so the maximum value is 2147483647.
A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.
Although the "nextval" function is called during a transaction, it will have no effect if that
transaction is rolled back.
A sequence always generates 0 or consecutive positive numbers.
A sequence number can be set by calling the "setval" function.

Answer(s): B,E

Show Answer Next Question

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

Show Answer 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

Show Answer Next Question

Postgresql PGCES-02 Exam
PGCES-02 PostgreSQL CE 8 Silver (Page 3 )

QUESTION: 6

QUESTION: 7

QUESTION: 8

QUESTION: 9

QUESTION: 10

Join the PGCES-02 Discussion

Postgresql PGCES-02 Exam PGCES-02 PostgreSQL CE 8 Silver (Page 3 )

QUESTION: 6

QUESTION: 7

QUESTION: 8

QUESTION: 9

QUESTION: 10

Join the PGCES-02 Discussion

Postgresql PGCES-02 Exam
PGCES-02 PostgreSQL CE 8 Silver (Page 3 )