PostgreSQL_CE
PGCES-02 · Question #107
What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;
The correct answer is A. Requests a list of defined tables in the currently connected database. D. Requests the contents of the "tables" table in the "information_schema" schema. See the full explanation below for the reasoning.
Question
What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;
Options
- 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.
How the community answered
(19 responses)- A79% (15)
- B5% (1)
- C5% (1)
- E11% (2)
Community Discussion
No community discussion yet for this question.