Hi, today i attended iflex interivew, and I was very surpised to know that he asked all question from database except 2 qestion in
java !!
though i applied for java/j2ee !!
can you please tell me the answer for following quetions
Q what is the major similarities and difference b/w prepaired statement and StoredProcedures
I said Store procedures include function,cursor, while prepaired statement doesnot !!
please correct me
Q will the query will run faster on Delete/insert/Update query if table has Index on it ?
kindly tell me the answer
Q will the query will run faster Base table and transaction table has index or without index ?
??? kindly tell me the answer...
Q how can the
servlet be destroy, ? if servlet init method has created some instance object which are not being used as for v.long time no request is gone to that servlet !!!, so in order to free the resourse, how to remove the servlet
I said when container/application server shut-downs !! kindly tell me more answer
Kindly tell me some good source to really understand the concept of database stuff indepth technically ...written in easy way !
But i m not happy with iflex interiew approach.. as only 1 question is asked from java and all from database ... whats this..
Thanks
[ June 11, 2006: Message edited by: Amod Bhatia ]