Free Online PostgreSQL PGCES-02 Practice Test

Prepare Your PostgreSQL PGCES-02 Exam Questions with Free online PGCES-02 Practice Test. Get Brilliant CE 8 Silver Exam Results with Valid PGCES 02 Exam Dumps.

Page: 1 / 29

Total 145 Questions | Updated On: May 13, 2024

Add To Cart

Question 1

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 |

aaa@example.com | 1 3 |

bbb@example.com | 2 4 |

ccc@example.com | 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.

A : 0 rows

B : 1 row

C : 2 rows

D : 3 rows

E : 4 rows

Answer: A

Question 2

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

A : CREATE CLASS

B : CREATE FUNCTION

C : CREATE OPERATOR

D : CREATE DATABASE

E : CREATE TYPE

Answer: A

Question 3

Select two incorrect statements concerning PostgreSQL license.

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 4

The following table called 'company' is defined as follows:

id | name ----+--------

---------- 1 |

Pgsql,inc. 2 |

Postgres Co.,Ltd 3 |

SQL Company.

Select the most appropriate psql command for generating a text file company.txt on the client side with the following content: 1,'Pgsql,inc.' 2,'Postgres Co.,Ltd' 3,SQL Company.

A : \copy company TO 'company.txt' WITH ','

B : \copy company TO 'company.txt' WITH DELIMITER AS ','

C : \copy company TO 'company.txt' DELIMITER ','

D : \copy company TO 'company.txt'

E : \copy company TO company.txt CSV

Answer: A

Question 5

Select one statement which will cause a syntax error.

A : SELECT (SELECT item FROM sale WHERE id = 1);

B : SELECT * FROM (SELECT * FROM customer);

C : SELECT * FROM item WHERE cid IN(SELECT cid FROM customer);

D : SELECT * FROM sale WHERE name IN(SELECT name FROM names);

E : SELECT * FROM sale WHERE cid = ANY(SELECT cid FROM customer);

Answer: B

Page: 1 / 29

Total 145 Questions | Updated On: May 13, 2024

Add To Cart