You work as a MySQL Database Administrator. Your server crashed and it was recovered and made
online within half an hour. What will you do to ensure that the table structure and contents are in a
proper state?
A.
Peform a table optimization operation.
B.
Perform a table repair operation.
C.
Perform a table analysis operation.
D.
Perform a table check operation.
Explanation:
While working on MySQL database maintenance, a table check performs an integrity check to ensure
that the table structure and contents are
in a proper state. A table check can be performed for the MyISAM and InnoDB tables.
MySQL 5.7 Reference Manual :: 13.7.2.2 CHECK TABLE Syntax
CHECK TABLE checks a table or tables for errors.