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.

Join The Discussion