Ques 1 :
Which of the following is false regarding the Type 3 JDBC driver
(A) A Type 3 driver is a JDBC-Net pure Java driver
(B) This translates JDBC calls into a database -dependent net protocol.
(C) Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatest number of database servers.
Ques 2 :
Can we update a resultset programmatically?
Ques 3 :
Which type of JDBC driver is the fastest one?
(A) Type 4
(B) Type 3
(C) Type 2
(D) Type 1
Ques 4 :
Which of the following allows non repeatable read in JDBC Connection?
Ques 5 :
How many different types of resultset in JDBC?
Ques 6 :
JDBC-ODBC Bridge is platform independent driver.
Ques 7 :
What MySQL property is used to create a surrogate key in MySQL?
(D) None of the above -- Surrogate keys are not implemented in MySQL.
Ques 8 :
what is jdbc ?
Ques 9 :
Whatâ??s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?
(A) Both types of result sets will make changes visible if they are closed and then reopened.
(B) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.
(C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.
(D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read only while one that is TYPE_SCROLL_SENSITIVE does not.
Ques 10 :
Which driver is efficient and always preferable for using JDBC applications?
Ques 11 :
Which of the following is false as far as type 4 driver is concern?
(A) Type 4 driver is "native protocol, pure java" driver
(B) Type 4 drivers can not be used with Netscape
(C) Type 4 drivers are 100% Java compatible
(D) Type 4 drivers uses Socket class to connect to the database
Ques 12 :
Which JDBC driver Type(s) can be used in either applet or servlet code?
(A) Both Type 1 and Type 3
(B) Both Type 1 and Type 2
(C) Both Type 3 and Type 4
(D) Type 4 only
Ques 13 :
Which of the following methods are needed for loading a database driver in JDBC?
(A) registerDriver() method
(C) Both A and B
Ques 14 :
Is the JDBC-ODBC Bridge multi-threaded?
Ques 15 :
How many types of Statement in JDBC
Ques 16 :
Where is metadata stored in MySQL?
(A) In the MySQL database mysql
(B) In the MySQL database metadata
(C) In the MySQL database metasql
(D) In the MySQL database mysql
Ques 17 :
State true or false Can we retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column ?
Ques 18 :
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 running
(B) Most of the browsers cannot download java.* because of security reasons. Hence many vendors of all-Java JDBC drivers supply versions of the java.sql.* classes that have been renamed to jdbc.sql.*, along with a version of their driver that uses these modify
(C) Add import jdbc.sql.* in your applet code instead of java.sql.*, and add the jdbc.sql.* classes provided by your JDBC driver vendor to your applet's codebase, then all of the JDBC classes needed by the applet can be downloaded by the browser at run time,
(D) All of the above
Ques 19 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
Ques 20 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
Don't Refresh the Page !! ...