ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
   
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
 Question Submitted By :: Shyamvinay
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine
Answer
# 1
1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.

2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.

3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.
 
Is This Answer Correct ?    0 Yes 0 No
Rajanikanth
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
is it possible to assign two primary key in a table IBM7
what do you mean by longblob Data type in MySql?  3
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr  1
The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id  2
about foregine  2
Explain the difference between FLOAT, DOUBLE and REAL. Yahoo12
How many values can the SET function of MySQL take? Creative-Informatics2
How do you start MySQL on Linux?  3
how to take mysql database structure backup  6
how fastest access of data can be done from database ?  3
What are the other commands to know the structure of table using MySQL commands except explain command? SigmaTree2
Explain the difference between MyISAM Static and MyISAM Dynamic?  1
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com