Which table in the 'INFORMATION_SCHEMA' stores information about storage engines and server plugins?

Solution (By Examveda Team)

This question is about the INFORMATION_SCHEMA database in MySQL, which stores information about your database, tables, and other system-level details.

The question asks which table in the INFORMATION_SCHEMA holds information about storage engines (the software that manages your data storage) and server plugins (extra features that extend MySQL's functionality).

The correct answer is Option A: ENGINES, PLUGINS.

Here's why:

* ENGINES: This table stores details about available storage engines in your MySQL server, like InnoDB or MyISAM.
* PLUGINS: This table lists the server plugins installed and their configuration.

The other options are incorrect because:

* Option B: FILES, PLUGINS: FILES is a table in INFORMATION_SCHEMA that keeps track of data files.
* Option C: PLUGINS, STATISTICS: STATISTICS is a table that contains data related to table statistics, like cardinality and index usage.
* Option D: ENGINES, FILES: As explained earlier, FILES stores information about data files.

So remember, to find information about storage engines and server plugins in MySQL, you would query the ENGINES and PLUGINS tables within the INFORMATION_SCHEMA database.