Jdbc Interview Questions Answers Inwards Coffee - Two To Iv Years Experienced Programmer

JDBC Interview inquiry forms 1 of the of import department inwards Java Interviews. Similar to multithreading, Collection framework together with Garbage collection interview question, JDBC inquiry must move prepared past times whatever Java programmer. Most of questions from JDBC or Java database connectivity comes from API together with basic architecture of JDBC which equally good involves JDBC drivers. Influenza A virus subtype H5N1 proficient agreement of JDBC API along with database basics similar transactions equally good assist to do good inwards JDBC interviews. I own got collected some of frequently asked JDBC Interview question for quick reference. This volition assist to revise some of import JDBC concepts together with equally good orbit a peril to explore JDBC API to newcomers. If you lot own got whatever other JDBC interview question, which has been asked to you lot or friends, together with you lot intend it’s proficient to portion alongside Java community thus delight portion with us. Let's run into my eleven questions from JDBC, non thus tough but worth preparing.

12 JDBC Interview Questions with Answers

Here is my listing of interview questions from JDBC. This listing contains questions cast JDBC drivers, PreparedStatement, CallableStatement, JDBC Connection pool, SQL Date together with Timestamp API, ResultSet together with RowSet concepts together with couplet of JDBC inquiry from practical experience.

Question 1 : Difference betwixt SQL Date together with java.util.Date inwards Java

Answer : This is 1 of JDBC Questions which I similar to ask, because knowing how to correctly shop together with retrieve appointment inwards a database is often confusing for novel developers together with its rattling critical for whatever application. Main divergence betwixt SQL information i.e. java.sql.Date together with util appointment i.e. java.util.Date is that SQL Date alone contains appointment work together with non fourth dimension work but util appointment contains both appointment together with fourth dimension part. See SQL Date vs Util Date inwards Java for to a greater extent than differences betwixt them.

Question 2: What is do goodness of using PreparedStatement inwards Java

Answer : Another wonderful JDBC interview inquiry which is rattling pop on telephonic equally good equally on early on circular of Java Interviews. There are several benefits of using PreparedStatement piece querying database from Java programme e.g. meliorate surgical operation together with prevents from SQL Injection. I advise to read Why work PreparedStatement inwards Java for to a greater extent than benefits together with details on JDBC PreparedStatement.

Question 3: What is JDBC database Connection Pool? How to setup inwards Java?

Answer : I own got ever seen at to the lowest degree 1 inquiry related to database connecter puddle inwards JDBC Interview e.g. do goodness of using JDBC Connection pool. Well JDBC connecter puddle maintains puddle of JDBC connecter which is used past times application to query database. Since JDBC connecter are expensive it accept fourth dimension to create them which tin orbit notice irksome response fourth dimension of server if created during asking time. Creating them on application start-up together with reusing them number inwards meliorate performance. See How to setup JDBC Connection Pool inwards Java using Spring for to a greater extent than details on JDBC connecter puddle together with benefits it offer.

Question 4: What is divergence betwixt type 2 together with type four JDBC drivers inwards Java

Answer : This JDBC Interview inquiry is equally erstwhile equally Vector vs ArrayList or Hashtable vs HashMap. I recollect questions almost JDBC ODBC drivers asked during almost every fresher aeroplane interview.  Key divergence betwixt type 2 together with type four JDBC driver is that you lot only demand to include JAR file of JDBC driver inwards your classpath to connect database. See this link for to a greater extent than difference betwixt type 2 together with type four JDBC drivers.

Question 5: What is divergence betwixt java.sql.Time together with java.sql.TimeStamp inwards Java

Answer : This JDBC questions is similar to before JDBC interview inquiry java.sql.Date vs java.util.Date. Main divergence is that java.sql.Time degree doesn't comprise whatever appointment information on it piece java.sql.TimeStamp contains appointment information. See 4 divergence betwixt Time together with Timestamp inwards Java JDBC for to a greater extent than differences.

Question 6: What happens if nosotros telephone telephone resultSet.getInt(0) when Select query number only own got 1 column of integer type?

Answer : This is 1 of the tricky Java question which comes from JDBC. you lot may intend that it volition furnish outset column equally integer from Query number laid but unfortunately it doesn't. It throws InvalidColumnIndexException inwards JDBC because index for getXXX() or setXXX() inwards JDBC starts with 1. See How to ready InvalidColumnIndexException inwards JDBC for to a greater extent than details on this JDBC interview question.

Question 7: What is divergence betwixt RowSet together with ResultSet inwards JDBC?

Answer : One of the pop JDBC interview inquiry right away days. RowSet extends ResultSet together with add together back upwards for JDBC API to Java edible bean cistron model. Main divergence of ResultSet together with RowSet is RowSet beingness connected together with disconnected, which is some other follow-up JDBC question. RowSet makes it slowly to work ResultSet but equally I said you lot alone similar to work it to larn do goodness of disconnected together with connected RowSet.

Question 8: What is work of setAutoCommit(false) inwards JDBC ?

Answer : This is 1 of the JDBC Interview inquiry I touched on Top 10 JDBC best practices for Java programmer. making setAutoCommit(false) saves a lot of surgical operation equally it doesn't commit transaction automatically subsequently each query together with nosotros do batch update. It allows you lot to guide hold it using commit() together with rollback(). This has number inwards impressive surgical operation gain inwards DAO layer.

Question 9: How to telephone telephone stored physical care for from JDBC inwards Java?

Answer : This JDBC Interview inquiry is some other 1 you lot tin orbit notice add together on whatever often asked listing together with only can't afford non to prepare. Mostly asked to Java developers with 2 to four years experience. In its simplicity you lot tin orbit notice only say that CallableStatement is used to telephone telephone stored procedure, which may atomic number 82 questions similar how do you lot move past times parameters to stored physical care for from Java or difference betwixt IN together with OUT parameters inwards JDBC etc. It's worth to gear upwards this JDBC inquiry inwards detail. By the agency IN parameter is used to move past times input to stored physical care for together with OUT parameter is used to shop output furnish from stored procedure. IF your stored physical care for furnish multiple values than you lot tin orbit notice equally good work ResultSet to traverse all results.

Question 10: What is divergence betwixt Connected together with disconnected RowSet inwards JDBC?

Answer : I own got seen this JDBC inquiry asked equally a follow-up inquiry of previous JDBC interview inquiry RowSet vs ResultSet.  Main divergence betwixt connected together with disconnected RowSet inwards JDBC is that disconnected RowSet doesn't require JDBC Connection piece it's on disconnected state. This makes disconnected RowSet low-cal together with ideal to work inwards sparse clients, piece connected RowSet is only a wrapper some ResultSet. JDBCRowSet together with WebRowSet are 2 examples of connected RowSet while  a CachedRowSet is an lawsuit of disconnected RowSet which caches information inwards memory. Ideal for pocket-size information laid together with sparse Java clients with pocket-size retentiveness human foot print.

Question 11: What is divergence betwixt Statement, PreparedStatement together with CallableStatement inwards Java?

Answer : One of the classical JDBC interview question. Main divergence betwixt Statement together with PreparedSatement is surgical operation together with avoiding SQL Injection equally nosotros own got seen inwards Benefits of using PreparedStatement inwards Java. While CallableStatement has rattling specific work inwards JDBC together with used to telephone telephone stored physical care for from Java program

That's all on these eleven JDBC Interview questions together with answers article. As I said many times, JDBC questions are of import work of whatever Java interview, allow it substance Java or J2EE Interview together with you lot only can't ignore it. Always gear upwards JDBC good plenty to respond whatever JDBC Interview inquiry to perform good inwards Java interviews.

Further Learning
JSP, Servlets together with JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 together with 2
10 Tough substance Java Interview inquiry for practice

10 Coding Interview Questions together with Answers for Java programmer

Top 10 Web Service Interview Questions together with answers for Java guys

Top 10 Spring MVC Interview Questions with Answers

10 Android Interview Questions together with Answers for Java developers

10 Programming Questions In Addition To Exercises For Coffee Programmers

If yous convey simply started learning basics of Java programming linguistic communication or familiar amongst programming inwards either C or C++ hence these Java programming questions as well as exercises for you. It doesn't focus on detail percentage of Java but these coding exercises volition switch yous inwards programming mode.These are likewise neat way to master copy basic programming build similar if-else , loops similar for as well as while, break as well as croak on amongst loop,   Java operators e.g. arithmetics as well as logical operator, recursion, methods or functions as well as mutual Java API. You may likewise uncovering these Java programming questions inwards close of Java courses taught inwards school, colleges as well as diverse Java preparation courses. Even I convey started learning Java past times doing these exercises multiple times amongst dissimilar ways. They are interesting, gives feeling of accomplishment if yous consummate it. These Java programs looks uncomplicated but they are notwithstanding tricky for novice Java programmers. Try to solve these coding exercises past times yourself but if yous stuck yous tin forcefulness out depository fiscal establishment lucifer relevant links or of-course usage google to acquire to a greater extent than insight on them. You tin forcefulness out likewise see here to a greater extent than Java programming questions as well as exercises.

Java Programing Questions exercises for beginners to practices

Here is my listing of 10 Java programming questions or Java programs which tin forcefulness out assistance whatsoever beginner to acquire started inwards programming world. These are classics, pop as well as real effective. You tin forcefulness out usage either notepad or whatsoever Java IDE similar Eclipse or Netbeans for coding. See links for solution as well as hints.

1. Write a programme inwards Java to depository fiscal establishment lucifer if a release is fifty-fifty or strange inwards Java? (input 2 output true, input three : output false)

A release is called fifty-fifty if it is completely divisible past times 2 as well as strange if it’s non completely divisible past times two. For representative release four is fifty-fifty release because when yous create 4/2 , relaxation is 0 which agency four is completely divisible past times 2. On the other manus five is strange release because 5/2 volition resultant inwards relaxation equally 1. See here to uncovering how to depository fiscal establishment lucifer fifty-fifty as well as strange release inwards Java.

2. Write a programme inwards Java to uncovering out if a release is prime inwards Java? (input 7: output truthful , input nine : output false)

A release is called prime if it is divisible past times either itself or 1. There are many algorithm to uncovering prime numbers e.g. instead of dividing till number, partition upto foursquare origin of release may last enough. Start from simplest ane as well as than endeavor to solve this work amongst span of dissimilar ways. Here is ane way to check prime numbers inwards Java

3. Write Java programme to depository fiscal establishment lucifer if a release is palindrome inwards Java? ( 121 is palindrome, 321 is not)

A release is called a palindrome if release is equal to opposite of release e.g. 121 is palindrome because opposite of 121 is 121 itself. On the other manus 321 is non palindrome because opposite of 321 is 123 which is non equal to 321. See hither for solution of  checking if a release is palindrome or non inwards Java.

4. How to uncovering if a release is ability of 2 inwards Java? (1,2, four ability of 2, three is not)

This is unopen to other interesting Java programming exercise. This programme tin forcefulness out last solved using dissimilar ways e.g. using arithmetics operator or past times using flake shift operator.

5. Write programme to kind an integer array without using API methods?

Sorting questions are ane of the integral percentage of programming questions. There are many sorting algorithm out at that topographic point to kind whatsoever array inwards Java e.g. Bubble sort, Insertion sort, Selection kind or quick sort. Implementing sorting algorithm itself a expert programming exercise inwards Java. By the way hither is ane way to sort an integer array amongst Bubble kind algorithm inwards Java.

6. Write Java programme to depository fiscal establishment lucifer if a release is Armstrong release or not? (input 153 output true,  123 output false)

An Armstrong release of three digit is a release for which pith of cube of its digits are equal to release e.g. 371 is an Armstrong release because 3*3*3 + 7*7*7 + 1*1*1 = 371). See hither for sample Java program to check if a release is Armstrong release or not.

7. Write a programme inwards Java to opposite whatsoever String without using StringBuffer?

This is unopen to other classical Java programming question. You tin forcefulness out opposite String inwards diverse way inwards Java but 2 programming technique is used to create e.g. Iteration as well as Recursion. Try solving this work using Iteration kickoff past times using Java’s arithmetics operator as well as than expect to implement a recursive solution. Here is ane way to reverse String inwards Java without using StringBuffer.

8. Write a programme inwards Java to impress Fibonacci serial upwardly to given number? Write both iterative as well as recursive version.

Fibonacci serial a pop release serial as well as real pop programming enquiry inwards Java, inwards which release is equal to pith of previous 2 numbers, starting from third. Fibonacci serial is likewise a expert recursion exercise as well as ofttimes asked inwards Interviews equally well. Try doing this exercise past times using both Iteration e.g. loops as well as recursion. For assistance encounter How to impress Fibonacci serial inwards Java using recursion.

9. Write a Java programme to calculate factorial of an integer release ? Both iterative as well as recursive solution.

Calculating Factorial is likewise a classic recursion exercise inwards programming. Since factorial is a recursive function, recursion becomes natural selection to solve this problem. You simply demand to hollo upwardly formula for calculating factorial which is for n! its n*(n-1)*…1. hither is ane way to calculate Factorial inwards Java using recursion.

10. Print next construction inwards Java?

This programme is a expert exercise for mastering loops e.g. for loop as well as acre loop inwards Java. This likewise teaches you How to usage intermission as well as croak on tilt amongst loops inwards Java. By the way yous tin forcefulness out impress whatsoever graphic symbol as well as usage System.out.print() as well as System.out.println())

*

***

*****

***

*

These were unopen to programming questions as well as exercises for beginners learning Java programming language. This listing is uncomplicated as well as yous tin forcefulness out solve these coding exercises inwards whatsoever programming language. I am certain Java beginners volition uncovering these exercises interesting as well as useful. You tin forcefulness out likewise postal service whatsoever coding exercise which yous think tin forcefulness out assistance junior programmers to acquire programming as well as assistance converting logic to code.

Further Learning
The Coding Interview Bootcamp: Algorithms + Data Structures
Data Structures as well as Algorithms: Deep Dive Using Java
How to gear upwardly PATH for Java inwards Windows as well as Linux

How classpath plant inwards Java

Difference betwixt PATH as well as Classpath inwards Java

Difference betwixt JDK, JRE as well as JVM

How to run Java programme from dominance work inwards Windows