PostgreSQL PGCES-02 Exam - Topic 5 Question 87 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 87
Topic #: 5

[All PGCES-02 Questions]

Select one incorrect statement concerning the relational data model.

AIt expresses the real world in a collection of 2-dimensional tables called a relation.

BIt is a model based on set theory.

CIt has a logical structure independent of physical data structure.

DIt is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.

EIt is a model that was proposed by E.F . Codd in 1970.

Show Suggested Answer

Suggested Answer: D

by Iraida at Jul 03, 2025, 04:39 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Anna

2 months ago

Wait, are we sure about E? Codd's work was groundbreaking!

upvoted 0 times

...

Hollis

2 months ago

Totally agree with Willow, D is the odd one out.

upvoted 0 times

...

Lakeesha

2 months ago

A is correct, that's how relations work!

upvoted 0 times

...

Laquita

3 months ago

B is spot on, set theory is the foundation of this model.

upvoted 0 times

...

Willow

3 months ago

D sounds off, relational models aren't hierarchical.

upvoted 0 times

...

Cornell

3 months ago

I thought all the other options were accurate, but D really stands out as the odd one out.

upvoted 0 times

...

Lisbeth

3 months ago

I practiced a similar question, and I feel like the hierarchy mentioned in D doesn't fit with how relations work.

upvoted 0 times

...

Dominga

4 months ago

I'm not entirely sure, but I remember something about E.F. Codd proposing the model, so E might be correct.

upvoted 0 times

...

Carmen

4 months ago

I think option D sounds wrong because the relational model is more about tables than hierarchies.

upvoted 0 times

...

Helaine

4 months ago

Option A sounds right to me - the relational model does express the real world in 2-dimensional tables.

upvoted 0 times

...

Golda

4 months ago

I remember the relational model has a logical structure independent of the physical data structure, so I'll rule out option D.

upvoted 0 times

...

Veda

4 months ago

The relational model was proposed by Codd in 1970, so option E seems like the correct answer.

upvoted 0 times

...

Carri

4 months ago

Hmm, I'm a bit confused about the hierarchy part. I'll have to think through that one carefully.

upvoted 0 times

...

Nancey

5 months ago

I'm pretty sure the relational data model is based on set theory, so I'll go with option B.

upvoted 0 times

...

Valentin

7 months ago

I disagree, I think the incorrect statement is A because the relational data model does not necessarily have to be represented in 2-dimensional tables.

upvoted 0 times

...

Rashida

7 months ago

I believe the correct answer is D as well, because the relational data model is not based on a hierarchy.

upvoted 0 times

...

Wynell

7 months ago

Wow, D really threw me off. Hierarchy? In a relational model? That's as off-base as a fish on a bicycle!

upvoted 0 times

Noemi

5 months ago

B) It is a model based on set theory.

upvoted 0 times

...

Lemuel

6 months ago

A) It expresses the real world in a collection of 2-dimensional tables called a relation.

upvoted 0 times

...

Gene

7 months ago

I agree with Yan, D is incorrect because the relational data model does not have a multiple stage hierarchy.

upvoted 0 times

...

Norah

8 months ago

Option E is the one - Codd proposed the relational model back in 1970, that's a classic fact.

upvoted 0 times

...

Kristofer

8 months ago

A and B sound spot on to me. Can't go wrong with those choices.

upvoted 0 times

Florencia

7 months ago

E) It is a model that was proposed by E.F . Codd in 1970.

upvoted 0 times

...

Corazon

7 months ago

D) It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.

upvoted 0 times

...

Laila

7 months ago

C) It has a logical structure independent of physical data structure.

upvoted 0 times

...

Yan

8 months ago

I think the incorrect statement is D.

upvoted 0 times

...

Shakira

8 months ago

Option D is definitely incorrect. The relational model doesn't have a hierarchy structure, it's all about tables and relationships between them.

upvoted 0 times

Mary

7 months ago

C) It has a logical structure independent of physical data structure.

upvoted 0 times

...

Ailene

7 months ago

B) It is a model based on set theory.

upvoted 0 times

...

Delsie

7 months ago

A) It expresses the real world in a collection of 2-dimensional tables called a relation.

upvoted 0 times

...