The maximum number of indexes on MyISAM table is . . . . . . . .
A. 0
B. 1
C. 2
D. more than 1
Answer: Option D
Solution (By Examveda Team)
This question is about MyISAM tables in MySQL, which is a type of table storage engine.Indexes are special data structures that help MySQL find information in tables faster. Think of them like an index in a book, allowing you to quickly find a specific topic.
MyISAM tables can have more than one index. This means you can create multiple indexes to speed up searches on different columns in your table.
So the answer is Option D: more than 1.
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