Ques 1 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
Ques 2 :
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
Ques 3 :
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 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 allows non repeatable read in JDBC Connection?
Ques 6 :
what is jdbc ?
Ques 7 :
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 8 :
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 9 :
State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Ques 10 :
Which of the following statements is true regarding the failing of the class.forName in jdk 1.1.x.
(A) A workaround is to explicitly call the method DriverManager.registerDriver(new YourDriverClass).
(B) The problem is due to race condition in the class loader.
(C) The race condition prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.
(D) All the above.
Ques 11 :
Is the JDBC-ODBC Bridge multi-threaded?
Ques 12 :
How many JDBC drivers are there ?
Ques 13 :
Which method is used to find the number of column in ResultSet?
Ques 14 :
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 15 :
State true or false :- The JDBC-ODBC bridge from Sun's Java Software does not provide network access to desktop databases like Microsoft access by itself.
Ques 16 :
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
Ques 17 :
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 18 :
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 19 :
Which JDBC driver Type(s) can be used in either applet or servlet code?
(A) Both Type 1 and Type 2
(B) Both Type 3 and Type 4
(C) Both Type 1 and Type 3
(D) Type 4 only
Ques 20 :
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 ?
Don't Refresh the Page !! ...