?
REPAIR TABLE works with how many of the following?
REPAIR TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV
MyISAM, ARCHIVE, CSV
Answer & Solution
Correct Answer:
Option
B
The REPAIR TABLE command in MySQL is primarily used for repairing corrupted tables.
It is relevant for tables using the MyISAM storage engine.
MyISAM tables can become corrupted due to various reasons such as system crashes or unexpected shutdowns.
However, the REPAIR TABLE command does not apply to tables using the ARCHIVE or CSV storage engines.
Therefore, it only works with one of the provided storage engines, which is MyISAM.
Option A, 0, is incorrect because REPAIR TABLE works with at least one of the provided storage engines (MyISAM).
Option C, 2, is incorrect because REPAIR TABLE only works with one of the provided storage engines, not two.
Option D, 3, is incorrect because REPAIR TABLE does not work with all three of the provided storage engines; it only works with MyISAM.
It is relevant for tables using the MyISAM storage engine.
MyISAM tables can become corrupted due to various reasons such as system crashes or unexpected shutdowns.
However, the REPAIR TABLE command does not apply to tables using the ARCHIVE or CSV storage engines.
Therefore, it only works with one of the provided storage engines, which is MyISAM.
Option A, 0, is incorrect because REPAIR TABLE works with at least one of the provided storage engines (MyISAM).
Option C, 2, is incorrect because REPAIR TABLE only works with one of the provided storage engines, not two.
Option D, 3, is incorrect because REPAIR TABLE does not work with all three of the provided storage engines; it only works with MyISAM.
Join the Discussion
Login to post a comment or share your explanation.
Login