The CHECK TABLE command should be used...

The correct answer is A. To make sure a table has no structural problems. C. To make sure that no table data are corrupted. D. to improve performance by updating index distribution statistics on InnoDB tables. The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK…

MySQL Database Maintenance

Question

Options

ATo make sure a table has no structural problems.
BTo find out why a query takes a long time to execute on a given table.
CTo make sure that no table data are corrupted.
Dto improve performance by updating index distribution statistics on InnoDB tables.
ETo repair table structure problems.

How the community answered

(69 responses)

A
74% (51)
B
10% (7)
E
16% (11)

Explanation

The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK TABLE indicates that a table has problems, the table should be

Topics

#CHECK TABLE#table maintenance#data corruption#InnoDB index statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice