FULLTEXT indexes can be created only for . . . . . . . .
A. MyISAM
B. InnoDB
C. MEMORY
D. TRANSITION
Answer: Option A
Solution(By Examveda Team)
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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion