JDBC Multiple Choice Questions and Answers pdf free download

JAVA JDBC Multiple Choice Questions for freshers and experienced candidates interview preparation
1.  Which statements about JDBC are true?
2.  Which packages contain the JDBC classes?
3.  Which type of driver provides JDBC access via one or more ODBC drivers?
4.  Which type of driver converts JDBC calls into the network protocol used by the database management system directly?
5.  Which type of Statement can execute parameterized queries?
6.  How can you retrieve information from a ResultSet?
7.  How can you execute DML statements (i.e. insert, delete, update) in the database?
8.  How do you know in your Java program that a SQL warning is generated as a result of executing a SQL statement in the database?
9.  What is, in terms of JDBC, a DataSource?
10. What is the meaning of ResultSet.TYPE_SCROLL_INSENSITIVE
11. Are ResultSets updateable?
12. What statements are correct about JDBC transactions ?
13. How can you start a database transaction in the database?
14. What is the meaning of the transaction isolation level TRANSACTION_REPEATABLE_READ
15. What statements are correct about positioned updates (i.e. cursor updates) in ResultSets?
16. How can you execute a stored procedure in the database?
17. What happens if you call the method close() on a ResultSet object?
18. What happens if you call deleteRow() on a ResultSet object?
19. What statements are correct about batched insert and updates? 

20. What is correct about DDL statements (create, grant,...)?
21. The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
22. Which of the following allows non repeatable read in JDBC Connection?
23. Which of the following statements is false as far as different type of statements is concern in JDBC?
24. Which of the following methods are needed for loading a database driver in JDBC?
25. Which of the following is false as far as type 4 driver is concern?
26. To execute a stored procedure “totalStock” in a database server, which of the following code snippet is used?
27. Which driver is efficient and always preferable for using JDBC applications?
28. JDBC facilitates to store the java objects by using which of the methods of PreparedStatement setObject () 2. setBlob() 3. setClob()
29. Which statement is static and synchronized in JDBC API?
30. The JDBC-ODBC bridge is
31. All raw data types (including binary documents or images) should be read and uploaded to the database as an array of
32. The class java.sql.Timestamp has its super class as
33. BLOB, CLOB, ARRAY and REF type columns can be updated in
34. Which of the following methods finds the maximum number of connections that a specific driver can obtain?
35. Are prepared statements actually compiled?
36. When the message “No Suitable Driver” occurs?
37. Which driver is called as thin-driver in JDBC?
38. How many transaction isolation levels are defined in java.sql.Connection interface?
39. Which method is used to perform DML statements in JDBC?
40. What is the disadvantage of Type-4 Native-Protocol Driver?
41. Which isolation level prevents dirty read in JDBC, connection class.
42. State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements  per connection ?
43. Which of the following describes the correct sequence of the steps involved in making a connection with a database.
44. Two parts of JDBC 2.0 API are
45. Which of the following values can be replaced in the place of 1 and 2 below Statement
46. State true or false. Is the JDBC-ODBC bridge multithreaded ?
47. 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 ?
48. State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
49. ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
50. What servlet processor was developed by Apache Foundation and Sun?
51. How many copies of a JSP page can be in memory at a time?
52. JDBC stands for:

1 comments:

Interview questions answers pdf said...

Java Servlet Interview Questions and Answers
http://allinterviewquestionsandanswerspdf.blogspot.in/2016/06/top-25-java-servlet-interview-questions.html