The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

Solution (By Examveda Team)

This question is asking about where MySQL stores information about indexes. Indexes are special data structures that speed up data retrieval.

Let's look at the options:
Option A: FILES - This table holds information about data files, not index characteristics.
Option B: STATISTICS - This is the correct answer! The STATISTICS table holds information about the indexes in a table, including their type, size, and how they're used.
Option C: SCHEMATA - This table holds information about database schemas, like table definitions, but not index details.
Option D: VIEWS - This table contains information about virtual tables, which are not related to indexes.

So, the answer is Option B: STATISTICS.