Question

What is the maximum number of indexes on MyISAM table?

(a) 0

(b) 1

(c) 2

(d) more than 1

I got this question in an online interview.

The origin of the question is Putting PHP to Work in section MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

The correct answer is (d) more than 1

Explanation: In MySQL, for a MyISAM table, there can be more than one indexes. The data rows of the MyISAM table are stored in a data file and the index values are stored in a separate index file.