Examveda

The maximum number of indexes on MyISAM table is . . . . . . . .

A. 0

B. 1

C. 2

D. more than 1

Answer: Option D

Solution (By Examveda Team)

This question is about MyISAM tables in MySQL, which is a type of table storage engine.
Indexes are special data structures that help MySQL find information in tables faster. Think of them like an index in a book, allowing you to quickly find a specific topic.
MyISAM tables can have more than one index. This means you can create multiple indexes to speed up searches on different columns in your table.
So the answer is Option D: more than 1.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous