JDBC Interview Questions You'll Most Likely Be Asked

5 of 5 Stars!

Price: $19.95
Sale: $16.36
Save: 18% off


Qty. 
+-
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.
 
Table Of Contents
1. General Information
2. JDBC Drivers
3. Executing SQL Commands
4. Connection Objects
5. Connection Pooling
6. Distributed Transactions
7. Prepared Statement Object
8. Result Set Processing
9. Batch Commands
10. Transaction Processing
11. RowSet Objects
12. Exception Processing
13. Table, BLOB, CLOB & NCLOB Structures
14. SQLXML Objects
15. ARRAY Objects
16. Data Types
17. Stored Procedures
HR Questions
Index
 
Includes:
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
 
Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)
 
11. What is the basic structure of a Type 3 Net-Protocol driver?
Answer:
a) Java Application
b) JDBC API
c) Type 3 Driver code (in Java)
d) Server component
e) Database
 
14. What are a few advantages of this model over the first two?
Answer:
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?
Answer:
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?
Answer:
By using the ConnectionPoolDataSource implementation while implementing the DataSource Object.
 
62. How is the compiled request sent to the Driver?
Answer:

Using the executeUpdate() or executeQuery method with the populated string as an argument.