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

For which table does 'REPAIR TABLE' not work?

Answer & Solution
Correct Answer: Option D
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.