Question

To perform consistency checks on a MyISAM table the statement is _____________

(a) CHECK TABLE

(b) REPAIR TABLE

(c) ANALYZE TABLE

(d) OPTIMIZE TABLE

The question was asked in quiz.

The origin of the question is Performing Database Maintenance with the Server Running in chapter Database Maintenance, Backups and Replication of MySQL

Answer 1

The correct option is (a) CHECK TABLE

To explain: In order to perform consistency checks or table repairs on a MyISAM table a ‘CHECK TABLE’ or ‘REPAIR TABLE’ statement is issued. The ‘mysqlcheck’ program can also be invoked.