?
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.
Answer & Solution
Correct Answer:
Option
A
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.
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
Login to post a comment or share your explanation.
Login