Question No 1

Select two transaction isolation levels supported in PostgreSQL.

Choose the Choices:

Question No 2

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

Choose the Choices:

An index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.

By using an index effectively, searching and sorting performs faster.

There are B - tree, Hash, R - tree and GiST index types.

By creating an index, performance always improves.

Creating an unused index does not affect the performance of a database at all.

Question No 3

Select two incorrect statements regarding 'DOMAIN'.

Choose the Choices:

When defining a domain, you can add a default value and constraints to the original data.

Domain is a namespace existing between databases and objects such as tables.

A domain is created by 'CREATE DOMAIN'.

A domain can be used as a column type when defining a table.

To define a domain, both input and output functions are required.

Question No 4

Select two suitable statements regarding the data types of PostgreSQL.

Choose the Choices:

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 2dimensional data.

A large object data type can be used to store data of unlimited size.

Question No 5

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;

Choose the Choices:

Practice PostgreSQL PGCES-02 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

PGCES-02 Exam Features

PGCES-02 PDF Dumps