MySQL 8.0 Database Administrator — Question 23

Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

Answer options

• 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;

Correct answer: B, C

Explanation

The commands B and C are correct as they specifically query the database for index information related to the parts table in the manufacturing schema. Option A provides the table structure but does not show indexes, while option D retrieves column statistics, which are not relevant to indexes. Option E is incorrect as it uses an invalid syntax for retrieving index information.