Explore Fresh PostgreSQL PGCES-02 Questions Bank For Smart Prep

Vendor:	PostgreSQL
Exam Name:	PostgreSQL CE 8 Silver
Registration Code:	PGCES-02
Related Certification:	PostgreSQL Certified Engineer Certification
Exam Track:	PostgreSQL Development
Exam Audience:

Question: 1

Select two suitable statements about the BSD license from below.

AIf you make changes to the source code, feedback must be sent to the original developers.

BIt is used by open source software.

CUser registration is required.

DIt is defined by Free Software Foundation, Inc. (FSF).

ESoftware under the BSD license can be incorporated with any programs provided that the copyright notice appears in all copies.

Question: 2

Table "t1" is defined below. Table "t1" has a column "id" of type INTEGER, and a column "name" of type TEXT. t1: The following SQL is executed while client "A" is connected. BEGIN;

SELECT * FROM t1 WHERE id = 2 FOR UPDATE; SELECT * FROM t1 WHERE id = 1 FOR UPDATE; -- (*) While the second 'SELECT' statement, shown with (*), is being executed, a separate client "B" connects and executes the following SQL. Select the correct statement about the execution results. UPDATE t1 SET name = 'turtle' WHERE id = 2; Note: the default transaction isolation level is set to "read committed".

AThe update process for client 'B' is blocked until the current connection for client 'A' is finished.

BThe update process for client 'B' is blocked until the current transaction for client 'A' is finished.

CThe 'UPDATE' process for client 'B' proceeds regardless of the condition of client 'A'.

DThe process of client 'B' immediately generates an error.

EThe processes for both clients are blocked, and an error stating that a deadlock has been detected is generated.

Question: 3

The table "tbl" is defined below such that it could only store non-negative integers in the column "nn". Select the keyword that is applicable for the underlined blank. CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);

Question: 4

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

ASELECT 'ABC' . 'abc';

BSELECT cat('ABC', 'abc') FROM pg_operator;

CSELECT 'ABC' + 'abc';

DSELECT 'ABC' + 'abc' FROM pg_operator;

ESELECT 'ABC' || 'abc';

Question: 5

Select the most suitable statement about the PostgreSQL license from below.

APostgreSQL is distributed under the GPL license.

BPostgreSQL is distributed under the PostgreSQL license.

CPostgreSQL is distributed under the LGPL license.

DPostgreSQL is distributed under the BSD license.

EPostgreSQL is distributed under the X11(MIT) license.

Important PostgreSQL PGCES-02 Exam Questions

PostgreSQL CE 8 Silver PGCES-02 Exam