Examveda

A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

A. True

B. False

Answer: Option A

Solution (By Examveda Team)

This question asks about REPAIR TABLE in MySQL and its relation to upgrading your MySQL version.
REPAIR TABLE is used to fix errors in your database tables.
The USE_FRM option tells MySQL to use the table's .frm file (which contains the table structure) to help with the repair.
The answer:
While it's good practice to repair tables before upgrading, it's not mandatory.
So the answer is Option B: False.
You can upgrade even if you haven't used REPAIR TABLE with USE_FRM.
However, running REPAIR TABLE can help ensure your tables are in good shape before upgrading.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous