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

Solution (By Examveda Team)

This question is asking you about where MySQL stores information about table indexes. Indexes are like a table of contents for your data, making it faster to find specific rows.
Let's look at the options:
Option A: FILES - This table stores information about the physical files of your database. It doesn't hold details about indexes.
Option B: STATISTICS - This is the correct answer! This table stores various statistics about your tables, including information about indexes.
Option C: SCHEMATA - This table describes the schemas (structure) of your databases. It doesn't store details about indexes.
Option D: VIEWS - Views are virtual tables based on other tables. They don't directly contain information about indexes.
Therefore, the answer is Option B: STATISTICS.