ALLInterview.com :: Home Page KalAajKal.com
 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   To Refer this Site to Your Friends   Click Here
Google
 
Categories >> Software >> Databases >> MySQL
 
 


 

Back to Questions Page
 
Question
what is the difference between MyISAM and INNO DB in MySQL 
with the Advantage and disadvantage
Rank Answer Posted By  
 Question Submitted By :: Elango
This Interview Question Asked @   ABC
I also faced this Question!!   © ALL Interview .com
Answer
MyISAM and InnoDB are storage engines in MySql.
MyISAM does not support transactions while InnoDB support 
it.
 
0
Tushar
 
 
Answer
InnoDB: Row level locking, Transaction support, forgin key
constrant and crash recovery.

MyISAM: Much more conservate approach to disk space
management each MyISAM table store in a separate file. in
MyISAM memory and space usage, full text indexing support,
table based locking, bulk insert capabilities and speed are
plus factor but crushes recovery would be the horror story.

As general approach, if you have a more reads use MyISAM and
if you have a more update use InnoDB.
 
0
Sanjeev Chauhan
 
 
Answer
InnoDb table take More Disk space Comparing with MyISAM
InnoDB is Transactions safe means Data Integrity is 
maintained Throughout entire qry process.
InnoDB also provides Row-locking as opposed to table 
locking while 1 qry is busy with updating or inserting 
arow,another qry can update a different row at the same 
time.these features increases the multi user concurrency 
and Performance
Another greate feature is InnoDB boasts is the ability to 
use Foreign key constraints
 
0
Sreedevi Yadav
 
 
 
Question
what is the difrence between sql and pl/sql
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Wipro
I also faced this Question!!   © ALL Interview .com
Answer
In pl/sql there is three letter extra "pl/" but it was not
in sql
 
0
Karthik Krishnan
 
 
Answer
No.The above is not a correct one.
The appropriate answer is there is only 2 letters 
extra "pl" and one special charcter "/" extra.
 
0
Sudhakar Shanmugam
 
 
Answer
Usually we will used to mention pl/sql, so there are three
characters differing. And considering the special character
is mandatory.
 
0
Karthik Krishnan
 
 
Answer
Similarly i have many answers for the critical and vertical
questions.
Even you can reach me by mail-id.
karthik.krishnagiri@gmail.com
 
0
Karthik Krishnan
 
 
Answer
I donot know about the people posting answer here with 
correct sense or not. Beacuse many of candidate use this 
forum as reference. This kind of answers will mis guide 
them.
 
0
Rsr
 
 
Answer
Actually,

All those above answers are wrong..Because the question is 
itself wrong as it has a spelling mistake for "difference" 
and its displayed as "difrence".People like me only can 
find this error(Bug) as because i wear Specs.

For more exact answers please contact : aar.sundar@gmail.com
 
0
Rsr
 
 
Answer
Hello!!

If you people dont know the answer please atleast learn 
from my post. 

Ans : The main diffrence is ,SQL is only for team members 
but when the project lead uses it,then its named as 
ProjectLead SQL (shortly pl/sql)

So i think you people understood my technical knowledge, So 
for any answers contact me(Incoming free).
 
0
Mr.kiruba Sankar
 
 
Answer
Thanks for the reply and suggestions
But people Please dont talk jargunds.
Can someone comeup with an explanation understandable to a 
lay man.
Thanks in advance!!!
 
0
Sandhya
 
 
Answer
SQL is the strutctured query language but pl/sql is the
procedural language sql.difference is in pl/sql we can work
with data in the form by writing program which has
predefined structure. but sql does not have.
 
0
M.balarami Reddy
 
 
Answer
Differce B/W Pl/sql & sql is that pl/sql is used gor 
Logical databese Creation. it is used in backend . It is 
used for Programming.

sql is Used for front end & Used for Physical data base 
creation maintain tabes & rows.
 
0
Mayank Singh
 
 
Answer
Sql is structured query language and pl/sql is programing 
langugae that means you can use procedure ,function and 
other. in pl/sql you can store procedure and function in 
database and later these can be used.
 
0
Rahul
 
 
Answer
SQL is a data oriented language for selecting and
manipulating sets of data. PL/SQL is a procedural language
to create applications. You don't normally have a "SQL
application". You normally have an application that uses SQL
and a relational database on the back-end. PL/SQL can be the
application language just like Java or PHP can. SQL may be
the source of data for your screens, web pages and reports.
PL/SQL might be the language you use to build, format and
display those screens, web pages and reports.

Think of it like this: The code that makes your program
function is PL/SQL. The code that manipulates the data is
SQL DML. The code that creates stored database objects is
SQL DDL. DDL compiles the code that is written in PL/SQL.
PL/SQL may call SQL to perform data manipulation. The
commands that format the output of a tool are not related to
the SQL standard or to PL/SQL.
 
0
Antu
 
 
Answer
sql -> structure query language.
pl/sql -> procedure language in structure query language.
this is the main difference..
 
0
Anuj Maheshwari
 
 
Answer
SQL is a structured query language.
Actually SQL is a set of rules defined by mr.Codd.
Any database like oracle,derby or sybase has to follow 
these rules.We can say that database following maximum 
codd's rule(there are 12 rules) is better than other like 
oracle follows 11 rule so it is better than other.

there are different categories in SQL
MySql-->supports triggers and cursors
Pl/Sql-->supports procedures.
Tl/Sql-->supports transactions.
MSSql-->it is microsoft version of SQL.
 
0
Tushar Matere
 
 
Answer
SQL is structured query language which is used to retrive 
data from the database. Before 1974 it is known as Gupta 
SQL. In 1974 Relational solutions Inc(Now oracle 
corporation) taken it as a native lang to retrive data. 
Though it is structured quer language it is un structured 
its like simple english language. 

   Pl/Sql is an extension for Sql. It is a structured 4th 
generation language where one can execute more than one 
select statement with conditional constructs like if, then 
and else.
 
0
Kalyana Chakravarthy
 
 
Answer
SQL Enter, Edit, Store & Retrieve by single command or 
statement where as PL/SQL process all SQL statements one at 
a time. With PL/SQL, an entire block of statements process 
in a single command line. 

SQL in a strucutred query language; where pl/sql is 
procedures,function,variable,method all are present
 
0
Tonmoy Bhattacharya
 
 
Question
How MySQL is different from SQL?
Rank Answer Posted By  
 Question Submitted By :: Nauzer Kaifi
This Interview Question Asked @   HCL , IBM
I also faced this Question!!   © ALL Interview .com
Answer
In MySQL there is two letter extra "MY" but it was not in SQL
 
0
Ashok Kumar
 
 
Answer
there is no more difference in sql and mysql except syntex.
actually all most syntex is same. in mysql there is some
features which is seen like easy to understandable.
 
0
Anuj Maheshwari
 
 
Answer
if u don't know the correct answer then plz no need for any
answer..
Don't misguide anyone..
 
0
Antu
 
 
Answer
SQL is structural quary language but mysql is database package.
 
0
Antu
 
 
Answer
Ya ! MySQL is an opensource database but SQL is an microsoft
product..
 
0
Vimal
 
 
Answer
if u don't know the correct answer then plz no need for any
answer..
Don't misguide anyone..
Please don't say incorrect answer........
 
0
Sudhagar
 
 
Answer
SQL is stand for Structured Query Language, while My SQL is
Open Source Database Package.

SQL is used for Handling i.e(Data Retrieval, Data Deletion,
Data Modification) data which are stored in Mysql Database
Engine in the form of Tables, field(Rows) , Tupples (Columns).
 
0
Himanshu Patel
 
 
Answer
SQL (Structure Query Language) is a language that helps one 
to manipulate the data in a database by its 
SELECT,UPDATE,DELETE etc commands.Whereas MySQL is a 
database server which houses database on which sql queries 
are run.....

SQL can be used with various other db packages apart from 
mysql so therz nothing similar about both ,each one serves 
a diff purpose
 
0
Nazia
 
 
Answer
Sql is the regular RDBMS and depends on which database u are
using like
TSQL for microsoft
PLSQL for oracle and 
MSSQL is for IBM databases
means this MSSQL is the RDBMS which is used to work with IBM
database.

MYSQL is the type of RDBMS  and SQL is the main language for
retrieveing the data.
 
0
Dinesh Kumar
 
 
Question
i made a table in sql server 2000 and in a column i want to 
add image path of a picture present in my hardisk... so 
using insert statement how will i insert the path of the 
image in the table??
Rank Answer Posted By  
 Question Submitted By :: Arpit
This Interview Question Asked @   WebTech
I also faced this Question!!   © ALL Interview .com
Answer
suppose your url is c://documents/image1.jpg.

1st on ur form , put one this property. "ecytype=mulipleform".
by this , u can upload your file on your destination. and
store your path in a one variable and put it into your
insert query. this is way to insert a path in a database.
 
0
Anuj Maheshwari
 
 
Question
SQL:
1.	Write a queryto retrieve the author who was 
published a book at the youngest age?
2.	write a query to retrieve the no. of books 
published a each year in various languages?
3.	write a query to retrieve no. of books published by 
them only those authors who have published more than 1 book?
4.	write a query to retrieve who has not published any 
books during the year 2006?
5.	write a query to retrieve the authors who has 
published any books during the birth date  write this query 
in 2 ways 1)joins 2)sub query
6.	write a query to retrieve all the books which was 
published during jan 2007 & title containing India or 
published in the language hindi?


  1. table name is liberary managemnt and two column is 
there one is authors and another one is books .
2.four fields will comes under authours like nationality, 
birthdate ,first-language,second-language
3.four fields will comes under books like 
authour,title ,language,publish date  to write query using 
this details
Rank Answer Posted By  
 Question Submitted By :: Sureshasall
This Interview Question Asked @   Covansys
I also faced this Question!!   © ALL Interview .com
Answer
select * from published book where min(age);
 
0
Nani
 
 
Answer
select count(books),year(publish date)as 
Year_Published,language from library management a,books b 
where a.authour=b.authour group by Year_Published;
 
0
Vijay
[Aryans]
 
 
Answer
select count(a.books),year(b.publish date)as 
Year_Published,language from library management a,books b 
where a.authour=b.authour group by Year_Published;
 
0
Vijay
[Aryans]
 
 
Question
suppose server is running Suddenly down . what can you do?
but i want do not down the server?
Rank Answer Posted By  
 Question Submitted By :: Prasadhari_m@yahoo.com
I also faced this Question!!   © ALL Interview .com
Answer
By using clustering
Active\Active
Active\passive
 
0
Prasadhari_m@yahoo.com
 
 
Answer
Reduce the task given to the server
 
0
Jeyakannan M
 
 
Question
what is collation?
how many types of installations in sql server?
Rank Answer Posted By  
 Question Submitted By :: Prasadhari_m@yahoo.com
I also faced this Question!!   © ALL Interview .com
Answer
Collation is set of rules determine the how the data is 
sorted and compared
Case sensitiy collation
Accent Sensitity collation
Kane sensitiy collation
 
0
Prasadhari_m@yahoo.com
 
 
Answer
collation is actually a set of characters than can be 
changed from language to language. Means character set for 
latin is different from swedish or other language like 
chinese, japanese.
 
0
Tushar Matere
 
 
Question
How many services is running in sql server?
Rank Answer Posted By  
 Question Submitted By :: Prasadhari_m@yahoo.com
This Interview Question Asked @   ACC , V2 Solutions
I also faced this Question!!   © ALL Interview .com
Answer
one service will mainly run in the SQL server ie:SQL Server 
service
 
0
Prathiba
 
 
Answer
MS Sql Server-for running databases
MS Sql Agent - for running jobs
DTC(Distribution Transcation coordinator)-for connecting 
and linked to the other servers
 
0
Prasadhari_m@yahoo.com
 
 
Answer
no service runs in sql server
 
0
Dev Yadav
 
 
Question
How can you do the fine tunning?
Rank Answer Posted By  
 Question Submitted By :: Prasadhari_m@yahoo.com
This Interview Question Asked @   ACC
I also faced this Question!!   © ALL Interview .com
Answer
Fine tuning is mostly done for the SELECT statements.
Use the Keyword EXPLAIN in front Of your SELECT Statement.

eg: EXPLAIN SELECT t1.id, t2.id FROM table1 AS t1 INNER JOIN
TABLE2 AS t2 ON .....;
The result will be like this
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| id | select_type | table     | type | possible_keys   |
key             | key_len | ref   | rows | Extra       |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
|  1 | SIMPLE      | table1    | ref  |        t1       |  
     t1       |      4  | const |    2 | Using where |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
1 row in set (0.00 sec)

if the "ref" column value is found to be ALL, then the two
tables must be joined properly. if the "Extra"  gives values
like 
Using temporary; Using filesort then the columns  in the
JOIN conditions and WHERE clause must be indexed properly. 
By doing this we can make our queries executing faster.
 
0
Subeeshbabu V
 
 
Answer
If ur Television was not working means we have to do the
fine tuning.
Step 1:Take the Remote
Step2:Go the menu Control OR Program 
Step3: In Menu Control Or program u will see fine Tunning
Step4:Change the status of the arrow in fine tunning
Step5:if the Television still not working means
Step6: Take ur Television and go to beach. Jump into the sea
along with ur Television
 
0
Shankri
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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