1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

Which two commands display the indexes on the parts table in the manufacturing schema?

Choose two

A DESCRIBE manufacturing.parts;
B SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’ AND TABLE_NAME=’parts’;
C SHOW INDEXES FROM manufacturing.parts;
D SELECT * FROM information_schema.COLUMN_STATISTICS;
E EXPLAIN SELECT INDEXES FROM manufacturing.parts;

Explanation

MySQL exposes table index metadata through SHOW INDEXES, and through the INFORMATION_SCHEMA.STATISTICS table when it is filtered to the relevant schema and table. These return the index definitions for manufacturing.parts.

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ70

Community Discussion