ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

REPAIR TABLE works with how many of the following?
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.