Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database? If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA'…

The correct answer is A. Yes. The INFORMATION_SCHEMA database serves as a central repository for database metadata. It is a "virtual database" in the sense that it is not stored on disk anywhere, but it contains tables like any other database, and the contents of its tables can be accessed using SELECT like…

MySQL Information Schema

Question

Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database? If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' ORDER BY TABLE_NAME

Options

AYes.
BNo; the INFORMATION_SCHEMA database does not contain information on itself.
CNo; the WHERE clause is incorrect. The correct field name is TABLE_SCHEMATA.
DNo; there is no table in the INFORMATION_SCHEMA database called TABLES.

How the community answered

(46 responses)

A
76% (35)
B
15% (7)
C
2% (1)
D
7% (3)

Explanation

The INFORMATION_SCHEMA database serves as a central repository for database metadata. It is a "virtual database" in the sense that it is not stored on disk anywhere, but it contains tables like any other database, and the contents of its tables can be accessed using SELECT like any other tables. Furthermore, you can use SELECT to obtain information about INFORMATION_SCHEMA itself.

Topics

#INFORMATION_SCHEMA#TABLES table#self-referential query#metadata SELECT

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice