ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

FULLTEXT indexes can be created only for . . . . . . . .

Answer & Solution
Correct Answer: Option A
In MySQL, FULLTEXT indexes can be created only for tables that use the MyISAM storage engine.
FULLTEXT indexes allow for efficient searching of text data, enabling full-text search capabilities in MySQL.
The InnoDB storage engine, represented by Option B, does not support FULLTEXT indexes natively in MySQL. However, in recent versions, InnoDB has introduced support for FULLTEXT indexes with some limitations.
Options C and D (MEMORY and TRANSITION) are incorrect because neither of these storage engines supports FULLTEXT indexes in MySQL.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.