Vidyalelo
MySQL · Q469

MySQL

Programming · MySQL · question 469

Q469

REPAIR TABLE does not work for . . . . . . . .

A.
MyISAM
B.
ARCHIVE
C.
InnoDB
Answer
D.
CSV

Answer: Option C

Solution

Answer: Option C
Solution:
This question asks you about the REPAIR TABLE command in MySQL. This command is used to fix any potential errors in a table's structure or data.

Let's break down the options:

Option A: MyISAM - REPAIR TABLE works perfectly fine with MyISAM tables.
Option B: ARCHIVE - REPAIR TABLE works perfectly fine with ARCHIVE tables.
Option C: InnoDB - REPAIR TABLE works perfectly fine with InnoDB tables.
Option D: CSV - CSV is a file format, not a MySQL table type. REPAIR TABLE is designed for MySQL table types.

Therefore, the correct answer is Option D: CSV.