Which statement will display the status of the partitioning plug-in?

by

Which statement will display the status of the partitioning plug-in?INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= ‘partition’;Reference: https://dev.mysql.com/doc/refman/5.7/en/partitioning.html

Question:

Which statement will display the status of the partitioning plug-in?

Options:

SHOW STATUS PLUGINS WHERE Name= ‘PARTITIONING’;

SHOW PLUGINS WHERE Name= ‘partition’;

SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM

USE SYS SCHEMA; SHOW PLUGINS STATUS;

Correct Answer

The Correct Answer for this Question is

SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM

Leave a Comment