Postgresql PGCES-02 CE 8 Silver PGCES-02 Dumps in PDF

Free Postgresql PGCES-02 Real Questions (page: 3)

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

  1. SELECT 'ABC' . 'abc';
  2. SELECT cat('ABC', 'abc') FROM pg_operator;
  3. SELECT 'ABC' + 'abc';
  4. SELECT 'ABC' + 'abc' FROM pg_operator;
  5. SELECT 'ABC' || 'abc';

Answer(s): E



Select two correct descriptions about views.

  1. A view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.
  2. A view is a virtual table which does not exist.
  3. A view is created to simplify complicated queries.
  4. You can create a view with the same name as already existing tables.
  5. A view only exists while the postmaster is running, and is deleted when the postmaster stops.

Answer(s): B,C



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".

  1. The update process for client "B" is blocked until the current connection for client "A" is
    finished.
  2. The update process for client "B" is blocked until the current transaction for client "A" is
    finished.
  3. The 'UPDATE' process for client "B" proceeds regardless of the condition of client "A".
  4. The process of client "B" immediately generates an error.
  5. The processes for both clients are blocked, and an error stating that a deadlock has been
    detected is generated.

Answer(s): B



SQL statements were executed in the following order:
CREATE TABLE fmaster
(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ftrans
(id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE);
INSERT INTO fmaster VALUES (1, 'itemA');
INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
Select two SQL statements that will generate an error when executed next.

  1. INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);
  2. INSERT INTO ftrans VALUES (2, 1, '2007-07-07');
  3. UPDATE fmaster SET name = 'itemAX' WHERE id = 1;
  4. UPDATE fmaster SET id = 100 WHERE id = 1;
  5. UPDATE ftrans SET id = 200 WHERE id = 1;

Answer(s): A,C



Select three SQL statements which return NULL.

  1. SELECT 0 = NULL;
  2. SELECT NULL != NULL;
  3. SELECT NULL IS NULL;
  4. SELECT NULL;
  5. SELECT 'null'::TEXT;

Answer(s): A,B,D



Share your comments for Postgresql PGCES-02 exam with other users:

M
MortonG
10/19/2023 6:32:00 PM

question: 128 d is the wrong answer...should be c

J
Jayant
11/2/2023 3:15:00 AM

thanks for az 700 dumps

B
Bipul Mishra
12/14/2023 7:12:00 AM

thank you for this tableau dumps . it will helpfull for tableau certification

H
hello
10/31/2023 12:07:00 PM

good content

M
Matheus
9/3/2023 2:14:00 PM

just testing if the comments are real

Y
yenvti2@gmail.com
8/12/2023 7:56:00 PM

very helpful for exam preparation

M
Miguel
10/5/2023 12:16:00 PM

question 11: https://help.salesforce.com/s/articleview?id=sf.admin_lead_to_patient_setup_overview.htm&type=5

N
Noushin
11/28/2023 4:52:00 PM

i think the answer to question 42 is b not c

S
susan sandivore
8/28/2023 1:00:00 AM

thanks for the dump

A
Aderonke
10/31/2023 12:51:00 AM

fantastic assessments

P
Priscila
7/22/2022 9:59:00 AM

i find the xengine test engine simulator to be more fun than reading from pdf.

S
suresh
12/16/2023 10:54:00 PM

nice document

W
Wali
6/4/2023 10:07:00 PM

thank you for making the questions and answers intractive and selectable.

N
Nawaz
7/18/2023 1:10:00 AM

answers are correct?

D
das
6/23/2023 7:57:00 AM

can i belive this dump

S
Sanjay
10/15/2023 1:34:00 PM

great site to practice for sitecore exam

J
jaya
12/17/2023 8:36:00 AM

good for students

B
Bsmaind
8/20/2023 9:23:00 AM

nice practice dumps

K
kumar
11/15/2023 11:24:00 AM

nokia 4a0-114 dumps

V
Vetri
10/3/2023 12:59:00 AM

great content and wonderful to have the answers with explanation

R
Ranjith
8/21/2023 3:39:00 PM

for question #118, the answer is option c. the screen shot is showing the drop down, but the answer is marked incorrectly please update . thanks for sharing such nice questions.

E
Eduardo Ramírez
12/11/2023 9:55:00 PM

the correct answer for the question 29 is d.

D
Dass
11/2/2023 7:43:00 AM

question no 22: correct answers: bc, 1 per session 1 per page 1 per component always

R
Reddy
12/14/2023 2:42:00 AM

these are pretty useful

D
Daisy Delgado
1/9/2023 1:05:00 PM

awesome

A
Atif
6/13/2023 4:09:00 AM

yes please upload

X
Xunil
6/12/2023 3:04:00 PM

great job whoever put this together, for the greater good! thanks!

L
Lakshmi
10/2/2023 5:26:00 AM

just started to view all questions for the exam

R
rani
1/19/2024 11:52:00 AM

helpful material

G
Greg
11/16/2023 6:59:00 AM

hope for the best

H
hi
10/5/2023 4:00:00 AM

will post exam has finished

V
Vmotu
8/24/2023 11:14:00 AM

really correct and good analyze!

H
hicham
5/30/2023 8:57:00 AM

excellent thanks a lot

S
Suman C
7/7/2023 8:13:00 AM

will post once pass the cka exam

AI Tutor 👋 I’m here to help!