Examveda

For which table does 'REPAIR TABLE' not work?

A. MyISAM

B. ARCHIVE

C. CSV

D. InnoDB

Answer: Option D

Solution (By Examveda Team)

This question is about MySQL and a command called REPAIR TABLE.
REPAIR TABLE is used to fix problems within a table, like corrupted data. It basically checks for errors and tries to fix them.
Let's look at the options:
Option A: MyISAM - MyISAM is a type of storage engine in MySQL. REPAIR TABLE works for MyISAM tables.
Option B: ARCHIVE - ARCHIVE is another storage engine. REPAIR TABLE doesn't work for ARCHIVE tables.
Option C: CSV - CSV is a file format, not a storage engine. REPAIR TABLE works for tables stored in a database, not directly on files.
Option D: InnoDB - InnoDB is a commonly used storage engine. REPAIR TABLE works for InnoDB tables.
So, the answer is Option B: ARCHIVE.
In short, REPAIR TABLE won't fix problems in tables that use the ARCHIVE storage engine.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous