1Z0-873 · Question #98
What are some advantages of using the INFORMATION_SCHEMA database rather than using the SHOW command?
The correct answer is B. INFORMATION_SCHEMA is a feature of standard SQL, and SHOW is a MySQL specific C. You always use SELECT to retrieve any of the metadata. E. The information returned from the INFORMATION_SCHEMA can be stored in other tables. SHOW and mysqlshow have been available since very early releases of MySQL. As of MySQL 5, metadata access is enhanced through two additions: The INFORMATION_SCHEMA database serves as a central repository for database metadata. I t is a "virtual database" in the sense that it is…
Question
What are some advantages of using the INFORMATION_SCHEMA database rather than using the SHOW command?
Options
- AIt is faster than using SHOW commands.
- BINFORMATION_SCHEMA is a feature of standard SQL, and SHOW is a MySQL specific
- CYou always use SELECT to retrieve any of the metadata.
- DUsing the INFORMATION_SCHEMA can provide more concise information.
- EThe information returned from the INFORMATION_SCHEMA can be stored in other tables.
How the community answered
(32 responses)- A6% (2)
- B81% (26)
- D13% (4)
Explanation
SHOW and mysqlshow have been available since very early releases of MySQL. As of MySQL 5, metadata access is enhanced through two additions: The INFORMATION_SCHEMA database serves as a central repository for database metadata. I t 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 When you retrieve metadata from INFORMATION_SCHEMA by using SELECT statements, you have the freedom to use any of the usual SELECT features that you expect:
Topics
Community Discussion
No community discussion yet for this question.