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

Kenneth

4 days 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

6 days 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

...

Dannette

10 days ago

I agree with Devora. The command is requesting a list of defined tables in the currently connected database and in the 'information_schema' database.

upvoted 0 times

...

Devora

15 days ago

I think the correct descriptions are A and B.

upvoted 0 times

...