-
Which of the following statements is true regarding the two tier model of the JDBC driver model.
A) In this java applications interact directly with the database.B) A JDBC driver is required to communicate with the particular database management system that is being accessed.C) This model is referred to as the client/server configuration where user is the client and the machine that has the database is called the user.D) All of the above.
sanjayg_mnit
- Jan 14th, 2009
B) A JDBC driver is required to communicate with the particular database management system that is being accessed.
satheesh kumar. sriramaneni
- May 4th, 2006
B is the correct one here.
-
Fill in the blanks -- The full form of JDBC is _________________
A) Java Database connectivity
-
How many JDBC drivers are there ?
A) 2B) 4C) 3D) 1
-
Different types of exceptions in JDBC are1. BatchUpdateException2. DataTruncation3. SQLException4. SQLWarning
A) 1,2,3B) 1,3,4C) 1,2,4D) 1,2,3,4
-
What are the parameters used in Connection pooling?
ajaykjha
- Oct 24th, 2006
Creating a Connection object is one of the most expensive operations in database programming so we use connection pooling.When the application starts, a certain number of Connection objects are create...
damodar
- Apr 8th, 2006
Connection pooling is one the new features introduced in ODBC 3.0. Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Once a connection has been created a...
-
-
-
Retrieving data methods
what methods did you use for retrieving data form a ResultSet object
Mohit Pabari
- Oct 6th, 2011
The getX() method is used, where X is String or Int depending on the type used in the database.
debasish padhy
- Jul 15th, 2011
GetString() method is used to retrieve data from the resultset
-
What is the use of BLOB, CLOB datatypes in JDBC
vinaymudgil007
- Jun 8th, 2010
These are used to store large amount of data into database like images, movie etc which are extremly large in size.Thanks,Vinay
madhuhari
- Apr 16th, 2007
BLOB(Binary Large Object) and CLOB(CharacterLargeObject) are SQL2 datatypes, which are introduced in JDBC 2.0 version. Suppose you have a requirement like, you want to store your content of resume(la...
-
What is the state of Connection object after execution of Statement(Populated Result Set)?
vinaymudgil007
- Jun 8th, 2010
The connection object is still open after the excecution unless explicitly closed by Connection.close() method.
venu
- Apr 10th, 2007
The connection object is still active, meaning it is ready to execute another statement.
-
If 4 different drivers are loaded, & created 4 different statements calling diffener tables from same database, how driver is recognized for each statement?
-
-
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
A) TrueB) FalseExplanation: This is the new feature in the JDBC 2.0 API usage is Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
anitpatel
- Nov 6th, 2009
True. One has to call insertRow() programmatically to get the resultset data changes reflected in database. The CONCUR_UPDATABLE implementation can be driver specific. If driver does not support this mode of update, it will not allow the resultset update.
-
Which of the following is true regarding not finding the java.sql.DriverManager class.
A) This problem can be caused by running a JDBC applet in a browser that supports the JDK 1.0.2, such as Netscape Navigator 3.0. The JDK 1.0.2 does not contain the JDBC API, so the DriverManager class typically isn't found by the Java virtual machine runningB) Most of the browsers cannot download java.* because of security reasons. Hence many vendors of all-Java JDBC drivers supply versions of the...
ajay
- Nov 21st, 2014
A
-
Fill in the blanks -- The full form of ODBC is ___________
A) Open DataBase connectivity
-
Which of the following is false for the Type 4 drivers in java
A) Type 4 driver, or, "native protocol, pure Java" driver converts JDBC calls into the network protocol used by the database directly.B) A Type 4 driver requires no client software, so it's ideal for deployment to browsers at runtime.C) As Type 4 drivers are 100% Java, use Java sockets to connect to the database, and require no client-side data access code, they are ideal for applets or other download...
-
Fill in the blanks :- The interface _____________ helps us in retrieving the information about the database.
A) java.sql.DatabaseMetaData.B) java.sql.resultsetmetadata
Chaithanya
- Oct 27th, 2014
DatabaseMetaData
-
-
How to create Container Managed Persistance program in EJB and tell me the procedure to deploy in Weblogic server.
Abdul Gafoor
- Feb 12th, 2006
My name is Abdul Gafoor, I am a sun certified J2EE Developer.I am using Weblogic 8.1 server.Compile bean and interface program.create jar file.Before the deploy jar file.You must create connection poo...
-
Difference between local and global transaction?
vinaymudgil007
- Jun 8th, 2010
The primary difference is that local transaction are single JVM level while global transaction are at multiple JVM level and hence global transactions need different design approach [which can be clas...
ak40732
- Mar 21st, 2006
A transaction is atomic unit of Work.The tasks which are made into the transaction act as a unit which can be executed successfully all,or if at least one task fails to its promise ,then the effect of...
JDBC Interview Questions
Ans