Q692
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.
A.
True
AnswerB.
False
Answer: Option A
Solution
Answer: Option A
Solution:
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.