Ques 1 :
Can we update a resultset programmatically?
Ques 2 :
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 3 :
Which of the following allows non repeatable read in JDBC Connection?
Ques 4 :
Which type of JDBC driver is the fastest one?
(A) Type 4
(B) Type 3
(C) Type 2
(D) Type 1
Ques 5 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
Ques 6 :
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 7 :
Is the JDBC-ODBC Bridge multi-threaded?
Ques 8 :
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 9 :
Which of the following statement is false regarding the use of setAutoCommit() in JDBC
(A) When a connection is created, it is in auto-commit mode.
(B) If the value is true each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed.
(C) once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitly
(D) By default the JDBC call is in auto-commit mode.
Ques 10 :
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 11 :
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 12 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
Ques 13 :
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 14 :
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 15 :
Which driver is efficient and always preferable for using JDBC applications?
Ques 16 :
Which of the following methods are needed for loading a database driver in JDBC?
(A) registerDriver() method
(C) Both A and B
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 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 19 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
Ques 20 :
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.
Don't Refresh the Page !! ...