iflex interview

[Amod Bhatia]

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 ]

[Sumit Chopra]

Why did'nt you tell them that you are not good in databases ? You should probably told them what all your areas of strength are and thus have diverted the questions to areas of your strength.

I had attended the Iflex interview about 20 months back in their Ville-Parle office for j2ee position. That time I had 1.5 yrs exp. The questions were good. I got the offer as well but did not accept for some reasons particularly salary was quite low for a costly city like Bombay.

[Mohan Karthick]

even if you are Java developer, these question should answered by you, but its depend on experience also.

servlet needs to be garbage collected which is out of programm control. shutting down is partially correct answer but it will not solve the purpose because application will stop processing.

index is always help in database processing and JDBC code works faster.

[Mahesh swami]

---------------------------------------------------------------------------
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
---------------------------------------------------------------------------

The similarity is that both preparedStatement & Stroed Procedure are precompiled on the database. Hence database need not create a query plan ateach execution time

The difference is that you you can write DB programming logic in Stored Procedure, pass IN,OUT , IN-OUT paramaters, use variables, conditional logic etc,
With PreparedStatments you can only execute parameterised SQL queries.

---------------------------------------------------------------------------
Q will the query will run faster on Delete/insert/Update query if table has Index on it ?
---------------------------------------------------------------------------
The query will run slower if indexes are used. This is because the databse alos need to update the index table aliong with your actual table for insert, delete, update operations.

But for select queries using coulmns with indexes for search, it will definitely improve performance!!!

[Kj Reddy]

Originally posted by Mohan Karthick:

index is always help in database processing and JDBC code works faster.

Indexes degrades the performance for modifying records. Whenever a record is modified in a table the indexes on the data must be updated. So the query will run slower for Update/Delete queries.

[Manish Hatwalne]

They all look good questions to me! iFlex is basically a company working n a finance domain, so DB related stuff is definitely expected.

There was one good, thick book on basic SQL and databases by Oracle Press, see if you can get that one.

- Manish

[Mohan Karthick]

Need read database also.