JDBC Interview Questions You'll Most Likely Be Asked is a perfect companion to stand ahead above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer.
a) 200 JDBC Interview Questions, Answers and Proven Strategies for getting hired as an IT professional
b) Dozens of examples to respond to interview questions
c) 51 HR Questions with Answers and Proven strategies to give specific, impressive, answers that help nail the interviews
d) 2 Aptitude Tests download available on www.vibrantpublishers.com
11. What is the basic structure of a Type 3 Net-Protocol driver?
a) Java Application
b) JDBC API
c) Type 3 Driver code (in Java)
d) Server component
14. What are a few advantages of this model over the first two?
a) Performance: This type of driver is the most efficient of the four mentioned above.
b) Flexibility: A single driver can handle more than one database.
c) Allows access to higher end features such as load balancing, caching, and advanced system administration functions.
d) The Java based driver can be ported easily.
e) It is suitable for web programming.
f) Easy to scale and optimize.
g) Can be made small and fast.
15. What are some disadvantages of the type 3 driver?
a) The intermediate server brings its own tasks to the maintenance work load.
b) Using a back end server can be less efficient when processing large portions of the data set.
44. How do you take advantage of connection pooling?
By using the ConnectionPoolDataSource implementation while implementing the DataSource Object.
62. How is the compiled request sent to the Driver?
Using the executeUpdate() or executeQuery method with the populated string as an argument.
73. List two ways to retrieve the final record in the ResultSet object?
a) Use the last method to position the cursor to the last record in the set.
b) Use the AfterLast method to position the cursor beyond the last record in the set and use the previous method to move the cursor back to the last record.
100. What is Auto Commit Mode?
It is the default mode of any connection, and it forces the results of each SQL statement to be committed as soon as the statement is executed.
130. What can the FilteredRowSet do that the WebRowSet cannot?
It can filter data contained within the RowSet while remaining in a disconnected state.
198. How is a stored procedure call set up in the application?
Using the prepareCall method in the Connection object.
199. How is the stored procedure executed?
Using the executeQuery method in the object created by the prepareCall method of the connection object.