Java JDBC Test 4 | JDBC online quiz, Online practice Test - Java Test
Finish Quiz
0 of 20 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
Information
Java JDBC Test 4 | JDBC online test, Online practice Test. Free Java JDBC Quiz. JDBC Online Quiz – Learning JDBC in simple and easy steps using our Test. The purpose of this Free Java online test is to help you evaluate your JDBC knowledge yourself via online mode.
This paper has 20 questions.
Time allowed is 25 minutes.
The Java JDBC Mock Test is Very helpful for all students. Now Scroll down below n click on “Start Quiz” or “Start Test” and Test yourself.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Not categorized 0%
| Pos. | Name | Entered on | Points | Result |
|---|---|---|---|---|
| Table is loading | ||||
| No data available | ||||
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Answered
- Review
-
Question 1 of 20
1. Question
Is the JDBC-ODBC Bridge multi-threaded?
Correct
The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made to ODBC. The concurrent access from multiple threads is not supported by the bridge
Incorrect
The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made to ODBC. The concurrent access from multiple threads is not supported by the bridge
-
Question 2 of 20
2. Question
Can we update a resultset programmatically?
Correct
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet uprs = stmt.executeQuery(“SELECT COLUMN_1, COLUMN_2 FROM TABLE_NAME”);
//move the cursor to the specific position and use related method to update data and then, call updateRow() method.
uprs.last();
uprs.updateFloat(“COLUMN_2”, 25.55);//update last row’s data
uprs.updateRow();//don’t miss this method, otherwise,Incorrect
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet uprs = stmt.executeQuery(“SELECT COLUMN_1, COLUMN_2 FROM TABLE_NAME”);
//move the cursor to the specific position and use related method to update data and then, call updateRow() method.
uprs.last();
uprs.updateFloat(“COLUMN_2”, 25.55);//update last row’s data
uprs.updateRow();//don’t miss this method, otherwise, -
Question 3 of 20
3. Question
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.Correct
Incorrect
-
Question 4 of 20
4. Question
Which method is used to find the number of column in ResultSet?
Correct
Incorrect
-
Question 5 of 20
5. Question
ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
Correct
Incorrect
-
Question 6 of 20
6. Question
How many JDBC drivers are there ?
Correct
Incorrect
-
Question 7 of 20
7. Question
State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Correct
Incorrect
-
Question 8 of 20
8. Question
Type-2 driver called-
Correct
Incorrect
-
Question 9 of 20
9. Question
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.
Correct
Incorrect
-
Question 10 of 20
10. Question
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
Correct
Incorrect
-
Question 11 of 20
11. Question
JDBC-ODBC Bridge is platform independent driver.
Correct
Incorrect
-
Question 12 of 20
12. Question
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Correct
Incorrect
-
Question 13 of 20
13. Question
Which type of JDBC driver is the fastest one?
Correct
Incorrect
-
Question 14 of 20
14. Question
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 ?
Correct
Incorrect
-
Question 15 of 20
15. Question
How many types of Statement in JDBC
Correct
Statement, PreparedStatement, CallableStatement
Incorrect
Statement, PreparedStatement, CallableStatement
-
Question 16 of 20
16. Question
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Correct
No, we can open only one statement object when using JDBC-ODBC Bridge.
Incorrect
No, we can open only one statement object when using JDBC-ODBC Bridge.
-
Question 17 of 20
17. Question
Which isolation level prevents dirty read in JDBC, connection class.
Correct
Incorrect
-
Question 18 of 20
18. Question
How many different types of resultset in JDBC?
Correct
Forward-only
As name suggest, this type can only move forward and are non-scrollable.
Scroll-insensitive
This type is scrollable which means the cursor can move in any direction. It is insensitive which means any change to the database will not show change in the resultset while it open.
Scroll-sensitive
This type allows cursor to move in any direction and also propagates the changes done to the database.Incorrect
Forward-only
As name suggest, this type can only move forward and are non-scrollable.
Scroll-insensitive
This type is scrollable which means the cursor can move in any direction. It is insensitive which means any change to the database will not show change in the resultset while it open.
Scroll-sensitive
This type allows cursor to move in any direction and also propagates the changes done to the database. -
Question 19 of 20
19. Question
Which JDBC driver Type(s) can be used in either applet or servlet code?
Correct
Incorrect
-
Question 20 of 20
20. Question
Is the JDBC-ODBC Bridge multi-threaded?
Correct
The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made to ODBC. The concurrent access from multiple threads is not supported by the bridge
Incorrect
The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made to ODBC. The concurrent access from multiple threads is not supported by the bridge