What will you do to ensure that the table structure and contents are in a proper state?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Lena

Lena

MySQL 5.7 Reference Manual :: 13.7.2.2 CHECK TABLE Syntax

CHECK TABLE checks a table or tables for errors.