Examveda

CHECK TABLE works with how many of the following?
MyISAM, ARCHIVE, CSV

A. 0

B. 1

C. 2

D. 3

Answer: Option D

Solution (By Examveda Team)

This question is about the CHECK TABLE command in MySQL and which storage engines it works with.

CHECK TABLE is a command that checks the consistency of a table, making sure all the data is in order and there are no errors.

Now, we have to figure out which storage engines work with CHECK TABLE. Storage engines are like different ways MySQL manages data in tables.

The options provided are:
* MyISAM: A commonly used storage engine for MySQL.
* ARCHIVE: A storage engine for storing data in a compressed form, mainly for read-only tables.
* CSV: A storage engine that treats tables as CSV files.

The correct answer is Option B: 1. Only MyISAM storage engine supports CHECK TABLE.

ARCHIVE and CSV storage engines don't have the functionality to perform table checks. They are designed differently and prioritize other features.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous