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 to use like conditions?

0 Answers  


How do you flush privileges?

0 Answers  


how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

0 Answers  


What is the command line end user interface - mysql?

0 Answers  


What is sql in mysql?

0 Answers  






What does "i_am_a_dummy flag" do in mysql?

0 Answers  


What are the advantages of stored procedures, triggers, indexes?

5 Answers  


Does adding an index lock a table?

0 Answers  


What is default password for mysql?

0 Answers  


What are the nonstandard string types?

0 Answers  


What is delimiter $$?

0 Answers  


How do I completely remove mysql from windows?

0 Answers  






Categories