Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
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 2 :
How many JDBC driver types does Sun define?
(A) One
(B) Two
(C) Three
(D) Four
Ques 3 :
Can we update a resultset programmatically?
(A) No
(B) Yes
Ques 4 :
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.
(A) True
(B) False
Ques 5 :
Which of the following methods are needed for loading a database driver in JDBC?
(A) registerDriver() method
(B) Class.forName()
(C) Both A and B
(D) getConnection()
Ques 6 :
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 7 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 8 :
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.
(D) a,b
Ques 9 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
(A) False
(B) True
Ques 10 :
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 11 :
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 12 :
How many different types of resultset in JDBC?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 13 :
Which driver is efficient and always preferable for using JDBC applications?
(A) Type-4
(B) Type-1
(C) Type-2
(D) Type-3
Ques 14 :
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 15 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 16 :
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 ?
(A) True
(B) False
Ques 17 :
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 18 :
Which method is used to find the number of column in ResultSet?
(A) getNumberOfColumn
(B) getMaxColumn
(C) getColumnCount
(D) getColumns
Ques 19 :
Which type of JDBC driver is the fastest one?
(A) Type 4
(B) Type 3
(C) Type 2
(D) Type 1
Ques 20 :
JDBC-ODBC Bridge is platform independent driver.
(A) False
(B) True
Submit Answer
Don't Refresh the Page !! ...
