Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
(A) True
(B) False
Ques 2 :
How many JDBC driver types does Sun define?
(A) One
(B) Two
(C) Three
(D) Four
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 :
Is the JDBC-ODBC Bridge multi-threaded?
(A) NO
(B) Yes
Ques 5 :
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 6 :
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 7 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
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?
(A) False
(B) True
Ques 10 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 11 :
Which of the following allows non repeatable read in JDBC Connection?
(A) TRANSACTION_READ_COMMITTED
(B) TRANSACTION_READ_UNCOMMITTED
(C) TRANSACTION_REPEATABLE_READ
(D) TRANSACTION_SERIALIZABLE
Ques 12 :
How many JDBC drivers are there ?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 13 :
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 14 :
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 15 :
Which method is used to find the number of column in ResultSet?
(A) getNumberOfColumn
(B) getMaxColumn
(C) getColumnCount
(D) getColumns
Ques 16 :
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 17 :
Which driver is efficient and always preferable for using JDBC applications?
(A) Type-4
(B) Type-1
(C) Type-2
(D) Type-3
Ques 18 :
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.
(A) 1,2,3,4
(B) 1,3,4,2
(C) 2,1,3,4
(D) 4,1,2,3
Ques 19 :
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 20 :
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.
Submit Answer
Don't Refresh the Page !! ...