Java - JDBC Multiple Choice Questions with answers for freshers and experienced free download

74 TOP JDBC Multiple Choice Questions with answers for freshers and experienced free download
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 (2 correct answers)?
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? (2 correct answers)
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? (2 answers)
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 PreparedStatement1. 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 of the following 2 methods executes faster ?
42. Integer.parseInt("12a") returns
43. By default, Strings to functions are passed using the method
44. What is the output of following program ?
45. How many String objects are created by the following statements ?
46. In the init(ServletConfig) method of Servlet life cycle, what method can be used to access the ServletConfig object ?
47. The Page directive in JSP is defined as follows:Then which of the implicit objects won’t be available ?
48. ejbCreate() method of CMP bean returns
49. How can a EJB pass it’s reference to another EJB ?Which of the following is correct syntax for an Abstract class ?
50. A JSP page is opened in a particular Session. A button is present in that JSP page onclick of which a new Window gets opened.
51. A class can be converted to a thread by implementing the interface ___
52. What is the output of following block of program ?
53. Which is not allowed in EJB programming ?
54. What happens if Database Updation code is written in ejbPassivate() method and if this method is called ?
55. A Vector is declared as follows. What happens if the code tried to add 6 th element to this Vector new vector(5,10)
56. Which is the data structure used to store sorted map elements ?
57. SessionListerner defines following methods
58. Which of the following is true ?
59. Stateful Session beans contain
60. What is the Life Cycle of Session bean ?Stateless session bean is instantiated by
61. A servlet implements Single Thread modelpublic class BasicServlet extends HttpServlet implements SingleThreadModel {int number = 0;public void service(HttpServletRequest req, HttpServletResponse res) {}}Which is thread safe ?
62. If you are trying to call an EJB that is timed out, what will happen ?
63. A method is defined in a class as :void processUser(int i) { }If this method is overriden in a sub class,_
64. In a JSP page, a statement is declared as follows:And below that, an _expression appears as:What is the output of this _expression,
65. Without the use of Cartesian product, how many joining conditions are required to join 4 tables ?
66. What is the output of following piece of code ?
67. The driver converts ________ method calls into native calls of the database API.
68. The type 3 driver is ________ as the platform-related differences are taken care by the middleware.
69. It is installed inside the ________ of the client.
70.  A JDBC driver is a software component enabling a Java application to interact with a ________.
71. The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the underlying operating system the ________ is running upon.
72. The middle-tier (application server) converts ________ calls directly or indirectly into the vendor-specific database protocol.
73. The type 4 driver is written completely in Java and is hence ________.
74. The JDBC type 4 driver, also known as the Direct to Database Pure Java Driver, is a database driver implementation that converts ________ calls directly into the vendor-specific database protocol.