The REPAIR TABLE command should be used...

The correct answer is C. To correct problems with a MyISAM table that have become corrupted. The REPAIR TABLE statement corrects problems in a table that has become corrupted. It works only for MyISAM tables.

MySQL Database Maintenance

Question

Options

ATo improve performance by updating index distribution statistics.
BAfter multiple modifications to a tables data.
CTo correct problems with a MyISAM table that have become corrupted.
DTo check a tables structure to see if it may have been damaged and needs repair.

How the community answered

(27 responses)

A
15% (4)
B
4% (1)
C
74% (20)
D
7% (2)

Explanation

The REPAIR TABLE statement corrects problems in a table that has become corrupted. It works only for MyISAM tables.

Topics

#REPAIR TABLE#MyISAM#table corruption#maintenance commands

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice