What are the different table present in MYsql?

Answers were Sorted based on User's Feedback

What are the different table present in MYsql?..

Answer / subrat

MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB

Is This Answer Correct ?    13 Yes 1 No

What are the different table present in MYsql?..

Answer / sankar

its not inoDB is InnoDB

Is This Answer Correct ?    9 Yes 1 No

What are the different table present in MYsql?..

Answer / rajesh kumar

BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do you start MySQL on Linux?

3 Answers  

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

what is the advantage of left outer join?

2 Answers  

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

0 Answers  

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

What is difference b/w composit key n primary key and forigion key?

4 Answers  

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  

how to take mysql database structure backup

6 Answers  

Can you save your connection settings to a conf file?

1 Answers  

What is check constraint?

3 Answers  

What is striped backup

0 Answers   Cap Gemini,

Give the syntax of GRANT commands?

3 Answers