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.

Join The Discussion