Ques 1 :
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
(A) A Java application
(B) A Java applet
(C) A Java servlet
(D) None of the above is correct.
Ques 2 :
Which of the following allows non repeatable read in JDBC Connection?
Ques 3 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
Ques 4 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 5 :
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 6 :
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 7 :
Type-2 driver called-
(A) Native-protocol, pure Java driver
(B) JDBC-Net, pure Java driver
(C) Native-API, partly Java driver
(D) JDBC-ODBC Bridge plus ODBC driver
Ques 8 :
How many JDBC driver types does Sun define?
Ques 9 :
Which of the following describes the correct sequence of the steps involved in making a connection with a database.
1. Loading the driver
2. Process the results.
3. Making the connection with the database.
4. Executing the SQL statements.
Ques 10 :
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
Ques 11 :
Which driver is efficient and always preferable for using JDBC applications?
Ques 12 :
How many different types of resultset in JDBC?
Ques 13 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
Ques 14 :
Is the JDBC-ODBC Bridge multi-threaded?
Ques 15 :
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 16 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
Ques 17 :
Which of the following methods are needed for loading a database driver in JDBC?
(A) registerDriver() method
(C) Both A and B
Ques 18 :
Which of the following statements is false as far as different type of statements is concern in JDBC?
(A) Regular Statement
(B) Interim Statement
(C) Callable Statement
(D) Prepared Statement
Ques 19 :
what is jdbc ?
Ques 20 :
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
(A) Type 1 only
(B) Type 2 only
(C) Both Type 3 and Type 4
(D) All of Type 1, Type 2, Type 3 and Type 4
Don't Refresh the Page !! ...