Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins?
(a) ENGINES, PLUGINS
(b) FILES, PLUGINS
(c) PLUGINS, STATISTICS
(d) ENGINES, FILES
(a) ENGINES, PLUGINS
(b) FILES, PLUGINS
(c) PLUGINS, STATISTICS
(d) ENGINES, FILES
Right choice is (a) ENGINES, PLUGINS
Best explanation: The ‘INFORMATION_SCHEMA’ is very useful in MySQL. It has many tables each serving its individual purpose. The storage engine information is stored in ENGINES and plugin information in PLUGINS.