PostgreSQL Exam PGCES-02 Topic 9 Question 34 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 34
Topic #: 9

What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;

ARequests a list of defined tables in the currently connected database.

BRequests a list of defined tables in the 'information_schema' database.

CRequests the contents of the 'tables' table in the 'information_schema' database.

DRequests the contents of the 'tables' table in the 'information_schema' schema.

ERequests a list of defined tables in the 'information_schema' schema.

Show Suggested Answer

Suggested Answer: A

by Goldie at Oct 26, 2022, 05:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Brittni

1 months ago

Ah, the classic information_schema query! I always get that mixed up with the system tables. At least it's not asking about the data dictionary, that would really make my head spin.

upvoted 0 times

Roosevelt

8 days ago

B) Requests a list of defined tables in the 'information_schema' database.

upvoted 0 times

...

Tracey

22 days ago

A) Requests a list of defined tables in the currently connected database.

upvoted 0 times

...

Titus

1 months ago

B is definitely wrong. The information_schema database is part of the current database, not a separate one. A and E are the right choices here.

upvoted 0 times

...

Mohammad

1 months ago

I'm pretty sure C and D are the right answers. The information_schema database stores table definitions, and this query is accessing the 'tables' table within that schema.

upvoted 0 times

...

Kenneth

2 months ago

I'm not sure about option C and D. I think they are incorrect because the command is not requesting the contents of a specific table, but rather a list of tables.

upvoted 0 times

...

Melinda

2 months ago

A and E are both correct. The statement requests a list of tables defined in the information_schema database, which contains metadata about the database itself.

upvoted 0 times