Question

In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

(a) FILES

(b) STATISTICS

(c) SCHEMATA

(d) VIEWS

I have been asked this question in an interview for internship.

My question comes from Controlling How the Server Listens for Connections in chapter General MySQL Administration of MySQL

Answer 1

Correct answer is (b) STATISTICS

To explain I would say: The ‘STATISTICS’ table in the ‘INFORMATION_SCHEMA’ stores information about the table index characteristics. ‘INFORMATION_SCHEMA’ is responsible for storing database metadata.