For what can the FULLTEXT indexes be created for?

Solution (By Examveda Team)

This question is about FULLTEXT indexes in MySQL. FULLTEXT indexes are used to speed up searches for text data. Let's break down the options:
Option A: MyISAM
MyISAM is a storage engine in MySQL. FULLTEXT indexes can be created for tables using the MyISAM storage engine.
Option B: InnoDB
InnoDB is another popular storage engine in MySQL. However, FULLTEXT indexes were not supported for InnoDB until MySQL 5.6.
Option C: MEMORY
The MEMORY storage engine stores data in RAM, which is very fast. However, FULLTEXT indexes are not supported for the MEMORY storage engine.
Option D: TRANSITION
The TRANSITION storage engine is not a real storage engine in MySQL. It is a placeholder that allows for smooth transitions between storage engines.
Therefore, the correct answer is Option A: MyISAM
Remember:
* FULLTEXT indexes are used to speed up searches for text data.
* They are supported for the MyISAM storage engine.
* They were not supported for InnoDB until MySQL 5.6.
* They are not supported for the MEMORY storage engine.