support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Postgresql
  4. PGCES-02

Free PGCES-02 Exam Braindumps
PGCES-02 PostgreSQL CE 8 Silver Questions 26–30 (page: 7)

Updated On: 9-Feb-2026
Page 7 of 30
PDF with 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



  PDF
Viewing page 7 of 30
Viewing questions 31 - 35 out of 142 questions


Post your Comments and Discuss Postgresql PGCES-02 exam prep with other Community members:

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