PostgreSQL Exam PGCES-02 Topic 1 Question 36 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 36
Topic #: 1

[All PGCES-02 Questions]

Select two incorrect statements concerning the system catalog.

AIt stores the object definition information for tables and columns.

BThere may be changes to specification by major version upgrades.

CIt is accessible as a table; however, it is output in binary format so it can not be read as is.

DIt stores the internal information of the database management system.

EIt is defined based on the standard SQL specification.

Show Suggested Answer

Suggested Answer: A

by Francine at Dec 11, 2022, 10:28 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Aliza

24 days ago

I heard the system catalog has a secret section just for database administrators' embarrassing stories. That's where the real juicy stuff is!

upvoted 0 times

Juan

19 days ago

A) It stores the object definition information for tables and columns.

upvoted 0 times

...

Herminia

1 months ago

Haha, I bet the folks who wrote this question are real system catalog experts! I'm going with B and D as the incorrect statements.

upvoted 0 times

Rolland

22 days ago

I think B is incorrect because there may not be changes to specification by major version upgrades.

upvoted 0 times

...

Tequila

2 months ago

I believe statement D is also incorrect. The system catalog stores object definition information, not internal information.

upvoted 0 times

...

Reyes

2 months ago

I agree with you, Anna. The system catalog is actually accessible as a table.

upvoted 0 times

...

Paulene

2 months ago

This is easy! C and E are the wrong ones. The system catalog is accessible as a table, and it's an internal database management system thing, not an SQL standard.

upvoted 0 times

Melissa

11 days ago

Exactly, C and E are the incorrect statements. The system catalog is accessible as a table and stores internal information of the database management system.

upvoted 0 times

...

Melissa

13 days ago

You're right, C and E are incorrect. The system catalog is not output in binary format and is not based on the SQL standard.

upvoted 0 times

...

Anna

2 months ago

I think statement C is incorrect.

upvoted 0 times

...

Eura

2 months ago

Hmm, I'd say A and E are the incorrect ones. The system catalog definitely stores object definitions, and it's not based on the SQL standard.

upvoted 0 times

Charolette

1 days ago

A and E are definitely incorrect. The system catalog stores object definitions and is not defined based on the SQL standard.

upvoted 0 times

...

Evangelina

5 days ago

Yes, A and E are the incorrect statements. The system catalog stores object definitions and is not based on the SQL standard.

upvoted 0 times

...

Tracie

6 days ago

I agree, A and E are definitely incorrect. The system catalog holds object definitions and is not defined based on the SQL standard.

upvoted 0 times

...

Vallie

19 days ago

I think A and E are incorrect. The system catalog does store object definitions, and it's not based on the SQL standard.

upvoted 0 times

...

Rodolfo

2 months ago

I think B and C are the incorrect statements. The system catalog should be accessible as a table, and major version upgrades shouldn't change its specification.

upvoted 0 times

...