The CHECK TABLE command...

The correct answer is E. May be used to check both InnoDB and MyISAM 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.

MySQL Database Maintenance

Question

Options

AWill cause an error when used on MyISAM tables
BWill cause an error when used on InnoDB tables
CWill ignore MyISAM tables
DWill ignore InnoDB tables
EMay be used to check both InnoDB and MyISAM tables

How the community answered

(29 responses)

B
3% (1)
C
14% (4)
D
7% (2)
E
76% (22)

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.

Topics

#CHECK TABLE#InnoDB#MyISAM#storage engine compatibility

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice