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

Postgresql PGCES-02 Exam (page: 6)
Postgresql PGCES-02 CE 8 Silver
Updated on: 25-Dec-2025

Viewing Page 6 of 30
PGCES-02 PDF 142 Questions

Select two suitable statements about major version upgrades of PostgreSQL from below.

  1. You can use the databases of the old major version.
  2. To use the data from the old version, you only need to replace the program.
  3. To use the data from the old version, you need to conduct a backup and restore.
  4. There is a possibility of configuration parameter changes after major version upgrades.
  5. Upgrade scripts can be executed while the old version of PostgreSQL is running.

Answer(s): C,D



Select one incorrect statement concerning the relational data model.

  1. It expresses the real world in a collection of 2-dimensional tables called a relation.
  2. It is a model based on set theory.
  3. It has a logical structure independent of physical data structure.
  4. It is made up of a multiple stage hierarchy where each of the set elements has parent child
    relationships.
  5. It is a model that was proposed by F. Codd in 1970.

Answer(s): D



Select two incorrect statements concerning PostgreSQL license.

  1. It can be used freely.
  2. It can be duplicated freely.
  3. It can be freely redistributed.
  4. Developers are responsible for its maintenance support.
  5. Developers are only responsible for handling its crucial faults.

Answer(s): D,E



Select the most suitable statement about PostgreSQL from below.

  1. PostgreSQL is a card-type database management system.
  2. PostgreSQL is a hierarchical database management system.
  3. PostgreSQL is a network-type database management system.
  4. PostgreSQL is an XML database management system.
  5. PostgreSQL is a relational database management system.

Answer(s): E



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

  1. PostgreSQL is distributed under the GPL license.
  2. PostgreSQL is distributed under the PostgreSQL license.
  3. PostgreSQL is distributed under the LGPL license.
  4. PostgreSQL is distributed under the BSD license.
  5. PostgreSQL is distributed under the X11(MIT) license.

Answer(s): D



Viewing Page 6 of 30



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

Joey 5/16/2023 5:25:00 AM

very promising, looks great, so much wow!
Anonymous


alaska 10/24/2023 5:48:00 AM

i scored 87% on the az-204 exam. thanks! i always trust
GERMANY


nnn 7/9/2023 11:09:00 PM

good need more
Anonymous


User-sfdc 12/29/2023 7:21:00 AM

sample questions seems good
Anonymous


Tamer dam 8/4/2023 10:21:00 AM

huawei is ok
UNITED STATES


YK 12/11/2023 1:10:00 AM

good one nice
JAPAN


de 8/28/2023 2:38:00 AM

please continue
GERMANY


DMZ 6/25/2023 11:56:00 PM

this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
UNITED KINGDOM


Jose 8/30/2023 6:14:00 AM

nice questions
PORTUGAL


Tar01 7/24/2023 7:07:00 PM

the explanation are really helpful
Anonymous


DaveG 12/15/2023 4:50:00 PM

just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
Anonymous


A.K. 6/30/2023 6:34:00 AM

cosmos db is paas not saas
Anonymous


S Roychowdhury 6/26/2023 5:27:00 PM

what is the percentage of common questions in gcp exam compared to 197 dump questions? are they 100% matching with real gcp exam?
Anonymous


Bella 7/22/2023 2:05:00 AM

not able to see questions
Anonymous


Scott 9/8/2023 7:19:00 AM

by far one of the best sites for free questions. i have pass 2 exams with the help of this website.
CANADA


donald 8/19/2023 11:05:00 AM

excellent question bank.
Anonymous


Ashwini 8/22/2023 5:13:00 AM

it really helped
Anonymous


sk 5/13/2023 2:07:00 AM

excelent material
INDIA


Christopher 9/5/2022 10:54:00 PM

the new versoin of this exam which i downloaded has all the latest questions from the exam. i only saw 3 new questions in the exam which was not in this dump.
CANADA


Sam 9/7/2023 6:51:00 AM

question 8 - can cloudtrail be used for storing jobs? based on aws - aws cloudtrail is used for governance, compliance and investigating api usage across all of our aws accounts. every action that is taken by a user or script is an api call so this is logged to [aws] cloudtrail. something seems incorrect here.
UNITED STATES


Tanvi Rajput 8/14/2023 10:55:00 AM

question 13 tda - c01 answer : quick table calculation -> percentage of total , compute using table down
UNITED KINGDOM


PMSAGAR 9/19/2023 2:48:00 AM

pls share teh dump
UNITED STATES


zazza 6/16/2023 10:47:00 AM

question 44 answer is user risk
ITALY


Prasana 6/23/2023 1:59:00 AM

please post the questions for preparation
Anonymous


test user 9/24/2023 3:15:00 AM

thanks for the questions
AUSTRALIA


Draco 7/19/2023 5:34:00 AM

please reopen it now ..its really urgent
UNITED STATES


Megan 4/14/2023 5:08:00 PM

these practice exam questions were exactly what i needed. the variety of questions and the realistic exam-like environment they created helped me assess my strengths and weaknesses. i felt more confident and well-prepared on exam day, and i owe it to this exam dumps!
UNITED KINGDOM


abdo casa 8/9/2023 6:10:00 PM

thank u it very instructuf
Anonymous


Danny 1/15/2024 9:10:00 AM

its helpful?
INDIA


hanaa 10/3/2023 6:57:00 PM

is this dump still valid???
Anonymous


Georgio 1/19/2024 8:15:00 AM

question 205 answer is b
Anonymous


Matthew Dievendorf 5/30/2023 9:37:00 PM

question 39, should be answer b, directions stated is being sudneted from /21 to a /23. a /23 has 512 ips so 510 hosts. and can make 4 subnets out of the /21
Anonymous


Adhithya 8/11/2022 12:27:00 AM

beautiful test engine software and very helpful. questions are same as in the real exam. i passed my paper.
UNITED ARAB EMIRATES


SuckerPumch88 4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.
UNITED STATES