PostgreSQL Exam PGCES-02 Topic 10 Question 32 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 32
Topic #: 10

[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: A

by Xochitl at Sep 17, 2022, 02:21 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Derick

7 days ago

Codd in 1970, huh? I bet he was the life of the party back then. 'Hey baby, wanna come back to my place and discuss set theory?'

upvoted 0 times

...

Rickie

10 days ago

Why do you think that?

upvoted 0 times

...

Ora

10 days ago

Option D is the clear winner here. Relational databases are about as hierarchical as a pancake. Flat is where it's at!

upvoted 0 times

...

Gladys

12 days ago

I disagree, I believe the incorrect statement is A.

upvoted 0 times

...

Jennifer

12 days ago

Hmm, I'm going to go with option D as the incorrect statement. Hierarchies are for those who can't handle the flat world of relations.

upvoted 0 times

...

Rickie

15 days ago

I think the incorrect statement is D.

upvoted 0 times

...

Karma

16 days ago

I think option B is the correct answer. The relational data model is indeed based on set theory, which is a foundational concept in its design.

upvoted 0 times

...

Adelina

19 days ago

Option D is definitely the incorrect statement here. The relational data model is not a hierarchy, it's a flat structure with tables and relations between them.

upvoted 0 times

...