ALLInterview.com :: Home Page            
 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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


  

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
why you need store procedure ? where do we use it in a Java 
project? can you get the code for as store procedure using in 
Java?
 Question Submitted By :: Krishna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Answer
# 1		 Stored procedure nothing but the set of SQLs which is
executed an controlled by database itself.Its useful when
you want to use the data from tables to be access
frequently.yes, we can get the same SQLs in java code as
well. Infact using Callable , stored procedures can be called. 
Is This Answer Correct ?    20 Yes 1 No
Guest
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is a Data File ?  1
How to define Data Block size ?  1
Difference between join and a subquery? Base-Automation6
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?  2
Which Oracle App Is Most Popular One ?  3
What is a Data Dictionary ?  5
what is trigger? Oracle6
what is insert all statement in sql CGI2
8. Display the client name and order date for all orders using the natural join keywords. Wipro1
how to get the no employee in each department including the dept which has 0 employee  3
what is the difference between UNION AND UNIONALL  4
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario? Wipro3
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

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