• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

iflex interview

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
Ranch Hand
Posts: 176
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 199
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
---------------------------------------------------------------------------
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!!!
 
Ranch Hand
Posts: 1704
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Ranch Hand
Posts: 2596
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 199
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Need read database also.
 
reply
    Bookmark Topic Watch Topic
  • New Topic