Java JDBC Test 3 | 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 Quiz 3 | JDBC online test, Online practice Test. Free Java JDBC Quiz. The purpose of this Free Java online test is to help you evaluate your JDBC knowledge yourself via online mode.
This paper has 30 questions.
Time allowed is 35 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
To execute a stored procedure â??totalStockâ?? in a database server, which of the following code snippet is used?
Correct
Incorrect
-
Question 2 of 20
2. Question
What MySQL property is used to create a surrogate key in MySQL?
Correct
Incorrect
-
Question 3 of 20
3. Question
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
Correct
Incorrect
-
Question 4 of 20
4. Question
Which driver is efficient and always preferable for using JDBC applications?
Correct
Incorrect
-
Question 5 of 20
5. Question
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?
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
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?
Correct
Incorrect
-
Question 17 of 20
17. 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 18 of 20
18. Question
Which isolation level prevents dirty read in JDBC, connection class.
Correct
Incorrect
-
Question 19 of 20
19. 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 20 of 20
20. Question
Which JDBC driver Type(s) can be used in either applet or servlet code?
Correct
Incorrect