QUESTION: 5

Select two suitable statements regarding the data types of PostgreSQL.

One field can handle up to 1GB of data.
'n' in CHARACTER(n) represents the number of bytes.
Only the INTEGER type can be declared as an array.
There is a non-standard PostgreSQL data type, called Geometric data type, which handles 2-dimensional data.
A large object data type can be used to store data of unlimited size.

Answer(s): A,D

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

Reveal Solution 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

Reveal Solution 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

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 2)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8