ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.