1.

MEMORY tables do not support BLOB and TEXT indexes.(a) True(b) FalseI have been asked this question in an online interview.Enquiry is from MySQL Data Types topic in division Data Types of MySQL

Answer»

The correct OPTION is (a) True

To elaborate: BLOB or TEXT columns sometimes can be indexed, depending on the STORAGE engine. MEMORY tables do not support BLOB and TEXT indexes. The MEMORY engine does not support BLOB or TEXT.



Discussion

No Comment Found

Related InterviewSolutions