Question 1

I would like to copy a database cluster directory for backup.

Select two incorrect statements from below.

Options :

A : The directory must be copied after stopping the database server.

B : When using the Tablespace function, it is necessary to back up the directory that stores the tablespace as well.

C : A database cluster that has been restored can be used on a separate machine with the same structure.

D : A database cluster that has been restored can be used on a newer version of PostgreSQL.

E : A database cluster that has been restored can be used on an older version of PostgreSQL.

Answer: A,D

Question 2

Select two incorrect statements concerning PostgreSQL license.

Options :

A : It can be used freely.

B : It can be duplicated freely.

C : It can be freely redistributed.

D : Developers are responsible for its maintenance support.

E : Developers are only responsible for handling its crucial faults.

Answer: A,D

Question 3

The table 'custom' is defined below. The 'id' column and 'introducer' column are of

INTEGER type, and the 'email' column is of TEXT type.

id | email | introducer ----+-- ---------------+-----------2 |

[email protected] | 1 3 |

[email protected] | 2 4 |

[email protected] | 2

Three SQL statements were executed in the following order:

UPDATE custom SET email = '' FROM custom c WHERE

custom.introducer = c.id; UPDATE custom SET introducer = NULL

WHERE introducer NOT IN (SELECT id FROM custom); DELETE

FROM custom WHERE id = 2 OR introducer = 2; Select the number of rows in the 'custom' table after the execution.

Options :

A : 0 rows

B : 1 row

C : 2 rows

D : 3 rows

E : 4 rows

Answer: A

Question 4

Select two SQL statements which abort a transaction.

Options :

A : END

B : ROLLBACK

C : TRUNCATE

D : ABORT

E : DROP TRANSTACTION

Answer: B,D

Question 5

Select the correct SQL statement to define a new data type.

Options :

A : CREATE CLASS

B : CREATE FUNCTION

C : CREATE OPERATOR

D : CREATE DATABASE

E : CREATE TYPE

Answer: A

Smartly Prepare Exam with Free Online PGCES-02 Practice Test

Buying Options: