Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Postgresql
  3. PGCES-02

Postgresql PGCES-02 CE 8 Silver PGCES-02 Exam Questions in PDF

Free Postgresql PGCES-02 Dumps Questions (page: 1)

PGCES-02 PDF — 142 Questions

Select two suitable statements regarding the following SQL statement:
CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

  1. It is defining a trigger "trigger_1".
  2. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
  3. The "write_log" function is called before 'UPDATE' takes place.
  4. 'UPDATE' is not executed if "write_log" returns NULL.
  5. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.

Answer(s): A,E



Select two transaction isolation levels supported in PostgreSQL.

  1. DIRTY READ
  2. READ COMMITTED
  3. REPEATABLE READ
  4. PHANTOM READ
  5. SERIALIZABLE

Answer(s): B,E



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

  1. An index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.
  2. By using an index effectively, searching and sorting performs faster.
  3. There are B-tree, Hash, R-tree and GiST index types.
  4. By creating an index, performance always improves.
  5. Creating an unused index does not affect the performance of a database at all.

Answer(s): D,E



Select two incorrect statements regarding 'DOMAIN'.

  1. When defining a domain, you can add a default value and constraints to the original data.
  2. Domain is a namespace existing between databases and objects such as tables.
  3. A domain is created by 'CREATE DOMAIN'.
  4. A domain can be used as a column type when defining a table.
  5. To define a domain, both input and output functions are required.

Answer(s): B,E



Select two suitable statements regarding the data types of PostgreSQL.

  1. One field can handle up to 1GB of data.
  2. 'n' in CHARACTER(n) represents the number of bytes.
  3. Only the INTEGER type can be declared as an array.
  4. There is a non-standard PostgreSQL data type, called Geometric data type, which handles 2-dimensional data.
  5. A large object data type can be used to store data of unlimited size.

Answer(s): A,D



Viewing page 1 of 30

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

R
Raj
9/12/2023 3:49:00 PM

can you please upload the dump again

UNITED STATES
C
Christian Klein
6/23/2023 1:32:00 PM

is it legit questions from sap certifications ?

UNITED STATES
A
anonymous
1/12/2024 3:34:00 PM

question 16 should be b (changing the connector settings on the monitor) pc and monitor were powered on. the lights on the pc are on indicating power. the monitor is showing an error text indicating that it is receiving power too. this is a clear sign of having the wrong input selected on the monitor. thus, the "connector setting" needs to be switched from hdmi to display port on the monitor so it receives the signal from the pc, or the other way around (display port to hdmi).

UNITED STATES
N
NSPK
1/18/2024 10:26:00 AM

q 10. ans is d (in the target org: open deployment settings, click edit next to the source org. select allow inbound changes and save

Anonymous
M
mohamed abdo
9/1/2023 4:59:00 AM

very useful

Anonymous
T
Tom
3/18/2022 8:00:00 PM

i purchased this exam dumps from another website with way more questions but they were all invalid and outdate. this exam dumps was right to the point and all from recent exam. it was a hard pass.

UNITED KINGDOM
E
Edrick GOP
10/24/2023 6:00:00 AM

it was a good experience and i got 90% in the 200-901 exam.

Anonymous
A
anonymous
8/10/2023 2:28:00 AM

hi please upload this

Anonymous
B
Bakir
7/6/2023 7:24:00 AM

please upload it

UNITED KINGDOM
A
Aman
6/18/2023 1:27:00 PM

really need this dump. can you please help.

UNITED KINGDOM
N
Neela Para
1/8/2024 6:39:00 PM

really good and covers many areas explaining the answer.

NEW ZEALAND
K
Karan Patel
8/15/2023 12:51:00 AM

yes, can you please upload the exam?

UNITED STATES
N
NISHAD
11/7/2023 11:28:00 AM

how many questions are there in these dumps?

UNITED STATES
P
Pankaj
7/3/2023 3:57:00 AM

hi team, please upload this , i need it.

UNITED STATES
D
DN
9/4/2023 11:19:00 PM

question 14 - run terraform import: this is the recommended best practice for bringing manually created or destroyed resources under terraform management. you use terraform import to associate an existing resource with a terraform resource configuration. this ensures that terraform is aware of the resource, and you can subsequently manage it with terraform.

Anonymous
Z
Zhiguang
8/19/2023 11:37:00 PM

please upload dump. thanks in advance.

Anonymous
D
deedee
12/23/2023 5:51:00 PM

great great

UNITED STATES
A
Asad Khan
11/1/2023 3:10:00 AM

answer 16 should be b your organizational policies require you to use virtual machines directly

Anonymous
S
Sale Danasabe
10/24/2023 5:21:00 PM

the question are kind of tricky of you didnt get the hnag on it.

Anonymous
L
Luis
11/16/2023 1:39:00 PM

can anyone tell me if this is for rhel8 or rhel9?

UNITED STATES
H
hik
1/19/2024 1:47:00 PM

good content

UNITED STATES
B
Blessious Phiri
8/15/2023 2:18:00 PM

pdb and cdb are critical to the database

Anonymous
Z
Zuned
10/22/2023 4:39:00 AM

till 104 questions are free, lets see how it helps me in my exam today.

UNITED STATES
M
Muhammad Rawish Siddiqui
12/3/2023 12:11:00 PM

question # 56, answer is true not false.

SAUDI ARABIA
A
Amaresh Vashishtha
8/27/2023 1:33:00 AM

i would be requiring dumps to prepare for certification exam

Anonymous
A
Asad
9/8/2023 1:01:00 AM

very helpful

PAKISTAN
B
Blessious Phiri
8/13/2023 3:10:00 PM

control file is the heart of rman backup

Anonymous
S
Senthil
9/19/2023 5:47:00 AM

hi could you please upload the ibm c2090-543 dumps

Anonymous
H
Harry
6/27/2023 7:20:00 AM

appriciate if you could upload this again

AUSTRALIA
A
Anonymous
7/10/2023 4:10:00 AM

please upload the dump

SWEDEN
R
Raja
6/20/2023 5:30:00 AM

i found some questions answers mismatch with explanation answers. please properly update

UNITED STATES
D
Doora
11/30/2023 4:20:00 AM

nothing to mention

Anonymous
D
deally
1/19/2024 3:41:00 PM

knowable questions

UNITED STATES
S
Sonia
7/23/2023 4:03:00 PM

very helpfull

UNITED STATES
AI Tutor 👋 I’m here to help!