What are some advantages of using the SHOW command rather than using the INFORMATION_SCHEMA?

The correct answer is A. It is available for releases older than MySQL 5.0. C. Using SHOW can provide more concise information. 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 is implemented. This provides better compliance with standard SQL because INFORMATION_SCHEMA is standard…

MySQL Information Schema

Question

Options

AIt is available for releases older than MySQL 5.0.
BIt returns results quicker than using the INFORMATION_SCHEMA.
CUsing SHOW can provide more concise information.
DSHOW is a feature of standard SQL, and INFORMATION_SCHEMA is a MySQL specific

How the community answered

(51 responses)

A
75% (38)
B
18% (9)
D
8% (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 is implemented. This provides better compliance with standard SQL because INFORMATION_SCHEMA is standard, not a MySQL-specific extension SHOW statement syntax is extended to support a WHERE clause for describing which rows to display. (Some SHOW statements support a LIKE clause for applying a pattern match to the rows of the result, but WHERE is more flexible.)

Topics

#SHOW command#INFORMATION_SCHEMA#MySQL 5.0 compatibility#concise output

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice