Examveda

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

A. ENGINES, PLUGINS

B. FILES, PLUGINS

C. ENGINES, FILES

D. PLUGINS, STATISTICS

Answer: Option A

Solution (By Examveda Team)

This question asks about where MySQL stores information about different storage engines and plugins.
Storage engines are responsible for how data is stored and retrieved.
Plugins are additional features that can be added to MySQL.
Let's break down the options:
Option A: ENGINES, PLUGINS
- ENGINES sounds like a good place for storage engine information.
- PLUGINS also seems like the right place for plugin data.
Option B: FILES, PLUGINS
- FILES is too broad and doesn't specifically relate to storage engines.
Option C: ENGINES, FILES
- Again, FILES is too general and doesn't focus on storage engines.
Option D: PLUGINS, STATISTICS
- STATISTICS is about data analysis, not storage engines or plugins.
Therefore, the most likely answer is Option A: ENGINES, PLUGINS.
This option makes the most sense because it directly relates to the information we're looking for.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous