Which of the following features are supported by MyISAM tables?

The correct answer is C. Auto_increment columns D. Fulltext indexes E. Assembly of multiple MyISAM tables to a MERGE table G. Table level locking. MyISAM has the most flexible AUTO_INCREMENT column handling of all the storage engines. MyISAM tables can be used to set up MERGE tables. MyISAM tables can be converted into fast, compressed, read-only tables to save space. MyISAM supports FULLTEXT searching and spatial data…

MySQL Storage Engines

Question

Options

AForeign key constraints
BTransactions
CAuto_increment columns
DFulltext indexes
EAssembly of multiple MyISAM tables to a MERGE table
FRow level locking
GTable level locking

How the community answered

(22 responses)

A
5% (1)
B
14% (3)
C
73% (16)
F
9% (2)

Explanation

MyISAM has the most flexible AUTO_INCREMENT column handling of all the storage engines. MyISAM tables can be used to set up MERGE tables. MyISAM tables can be converted into fast, compressed, read-only tables to save space. MyISAM supports FULLTEXT searching and spatial data types.

Topics

#MyISAM features#fulltext indexes#table locking#MERGE table

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice