Time remaining
:
:
Test Status
JDBCTEST2
Ques 1 :
How many JDBC drivers are there ?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 2 :
State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
(A) False
(B) True
Ques 3 :
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 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 :
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
(A) Type-1
(B) Type-2
(C) Type-3
(D) Type-4
Ques 6 :
JDBC-ODBC Bridge is platform independent driver.
(A) False
(B) True
Ques 7 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 8 :
Which type of JDBC driver is the fastest one?
(A) Type 4
(B) Type 3
(C) Type 2
(D) Type 1
Ques 9 :
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 10 :
How many types of Statement in JDBC
(A) 2
(B) 3
(C) 4
(D) 5
Ques 11 :
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 12 :
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
(A) No
(B) Yes
Ques 13 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 14 :
How many different types of resultset in JDBC?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 15 :
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 16 :
Is the JDBC-ODBC Bridge multi-threaded?
(A) NO
(B) Yes
Ques 17 :
Can we update a resultset programmatically?
(A) No
(B) Yes
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 method is used to find the number of column in ResultSet?
(A) getNumberOfColumn
(B) getMaxColumn
(C) getColumnCount
(D) getColumns
Ques 20 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
Submit Answer
Don't Refresh the Page !! ...