Question { 10374 }

What is the difference between Userdefined function and
stored procedure? Explain and give the example also

Answer

1. function always run with select command while stored
procedure execute with execute command

2. function not provide output parameter facility
while stored procedure provide output facility

3. function always execute means it execute more than one
time while store procedure execute only one time

Question { HCL, 147737 }

find out the third highest salary?

Answer

select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));

Question { Eforce, 31801 }

is there more the two primary key in a single table?

Answer

cannot add multiple primary key constraint on a single table

Question { Wipro, 6602 }

what is the main difference between myisam and innodb

Answer

both myisam and innodb are storange enginein sql.
innodb support transaction, foreign key while myisam not
support transaction.