-
Which of the following values can be replaced in the place of 1 and 2 belowStatement stmt = con.createStatement(1, 2);
A) ResultSet. TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLYB) ResultSet. TYPE_SCROLL_INSENSITIVE , ResultSet. CONCUR_UPDATABLEC) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_SCROLL_SENSITIVED) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_FORWARD_ONLY
-
Which of the statements is true regarding loading a driver in JDBC.1. registerDriver(Driver driver).2. Class.forName(java.lang.String driverclass)
A) 1B) 2C) 1, 2D) Neither of the above
-
Which of the following is not an isolation level in the JDBC.
A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_WRITEExplanation: it is TRANSACTION_REPEATABLE_READ and not TRANSACTION_REPEATABLE_WRITE
-
-
-
-
Changing function of a buttom.
Consider the following:-ID [_______]Name [_______]Marks [_______]NEW EDIT CLOSEThis is a form which I have made. What i need is When I click on NEW button, if textboxes should be cleared and the text on the NEW button should change to SAVE. the EDIT button should be disabled and CLOSE should change to CANCEL.I am able to change the text of the buttons using settext command...
-
Functionality of the cancel() method
What is the functionality of the cancel() method, provided in java.sql.Statement?
-
JVM and JDBC Connectivity
Explain working of Java Virtual Machine (JVM)
Explain the working cycle of the JDBC-ODBC connectivity? -
-
JDBC retrieve Row
How can we retrieve a whole row of data at once in JDBC ?
-
JDBC - Pre compile and Sored Procedure
As prepare statement also precompiles the SQL stmt & stored procedure also compiles the stmt once &den execute the same,then what is the diff between these 2 stmts?
-
JDBC ODBC Class Name
Why we call Class.forName() not Class.Name()?
-
-
-
What is JDBC Driver interface?
The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.
-
What are the common tasks of JDBC?
Create an instance of a JDBC driver or load JDBC drivers through jdbc.driversRegister a driverSpecify a databaseOpen a database connectionSubmit a queryReceive results
-
What are the flow statements of JDBC?
A URL string -->getConnection-->DriverManager-->Driver-->Connection-->Statement-->executeQuery-->ResultSet.
-
What Class.forName will do while loading drivers?
It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a DBMS.
-
How to Make Updates to Updatable Result Sets?
Another new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than having to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.E.g.Connection...
JDBC Interview Questions
Ans