1.

What is the maximum number of indexes on MyISAM table?(a) 0(b) 1(c) 2(d) more than 1I 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»

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.



Discussion

No Comment Found

Related InterviewSolutions