PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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