Examveda
Examveda

REPAIR TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV

A. 0

B. 1

C. 2

D. 3

Answer: Option B

Solution(By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous