ALLInterview.com :: Home Page KalAajKal.com
 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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Java J2EE  >>  Java Related  >>  JDBC
 
 


 

 
 Core Java interview questions  Core Java Interview Questions
 Advanced Java interview questions  Advanced Java Interview Questions
 Swing interview questions  Swing Interview Questions
 EJB interview questions  EJB Interview Questions
 Servlets interview questions  Servlets Interview Questions
 Struts interview questions  Struts Interview Questions
 JDBC interview questions  JDBC Interview Questions
 JMS interview questions  JMS Interview Questions
 SunOne interview questions  SunOne Interview Questions
 J2EE interview questions  J2EE Interview Questions
 Weblogic interview questions  Weblogic Interview Questions
 Websphere interview questions  Websphere Interview Questions
 Java Networking interview questions  Java Networking Interview Questions
 Java J2EE AllOther interview questions  Java J2EE AllOther Interview Questions
Question
How we say that PreparedStatment is Precompiled? where it 
will be compiled?
 Question Submitted By :: Rdharmendra
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How we say that PreparedStatment is Precompiled? where it will be compiled?
Answer
# 1
prepared Statements are compiled at database server side.
Once the statement is passed to the database the Statement 
is parsed for validness and checked weather the table exist
or not .if the statement is valid the server holds the
statement object and process the multiple request from  the
client.
Finally parsing of the statement is done at server side that
to only once.
 
Is This Answer Correct ?    4 Yes 1 No
Venkatesh.t
 
  Re: How we say that PreparedStatment is Precompiled? where it will be compiled?
Answer
# 2
When ever call the preparedstatement at firsttime,at that 
time, the statement will be parsing as a query string and 
create the object. This function will be doing in 
serverside.
 
Is This Answer Correct ?    1 Yes 0 No
Dsr
 
 
 
  Re: How we say that PreparedStatment is Precompiled? where it will be compiled?
Answer
# 3
prepared Statements are compiled at database server side.
Once the statement is passed to the database the Statement 
is parsed for valid and checked weather the table exist
or not .if the statement is valid the server holds the
statement object and process the multiple request from  the
client.
 
Is This Answer Correct ?    0 Yes 0 No
Paks Chaudhary
 

 
 
 
Other JDBC Interview Questions
 
  Question Asked @ Answers
 
What is the latest version of JDBC? What new features are added?  3
How to find total column from a resultset? tsys5
What is JDBC?  2
write down exceptions those appear in java programs when u write JDBC Programs?  2
What is the difference between triggers and procedures?  1
What is a Connection?  1
How the information about db(database) can be retrieved?  3
wa is connection pooling? how do u create connection pooling?wat is use connection pooling? Covansys1
Hi........I need to create a dropdown box using java.....this box should show the values that should be taken from the database...... Thank you....  1
What is 2-tier and 3-tier architecture? TCS1
Which Driver is preferable for using JDBC API in Applets?  1
What is the syntax of URL to get connection?  1
Difference between JDBC and Hibernate? Give one sample based on the variance? IBM2
dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me  1
wahts is mean by primary key and unique key? Wipro7
How do you debug PL/SQL code?  1
How a driver can be loaded?  1
what is call level interface?  1
What are the different types of modifiers?  1
When you will get error like ?No suitable driver??  1
 
For more JDBC 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 © 2007  ALLInterview.com.  All Rights Reserved.

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