SQL interview questions for Java developer

There are SQL interview questions for Java developer, because Java applications come in different shapes and sizes. The application could be just servlet based web application or it could use application frameworks like Spring or Struts. All enterprise Java applications have a common approach: they store data in a database like MS SQL, Oracle SQL or MySQL and use some framework to interact with that database. That framework ultimately translates the interaction into SQL statements, and those SQL statements need to be written by Java developer.

Every Java Developer resume indicates that developer has the database experience, an interviewer will definitely ask engineer a few common SQL interview questions to determine the depth of the knowledge in database area. The interviewer might use common database interview questions to decide whether interviewee have ever used T-SQL,PL/SQL or MySQL before or whether tailored the resume for an open Java developer position.

Without further ado, here they are SQL interview questions for Java Developer :

Beginner Level
Given an employees table with the columns EmpID, FirstName, LastName, StartDate, and EndDate:
Develop SQL query to return all employees currently working with last names starting with "Jon" sorted by last name then first name.

Easy Level
Using the same Employee table, plus a new table "PerformanceReviews" with the columns EmpID, and ReviewDate:
Develop SQL query to return the list of all employees who have never had a review sorted by StartDate.

Medium Level
Using the same Employee table, develop SQL query to show the difference in days between the most and least tenured employee currently working?

Hard Level
Working with Employee table, develop SQL query to print the longest period in days that the company has gone without headcount change.


On this page I put some SQL interview questions for Java Developer. These database interview questions are very simple and mainly were used to for interviewing Java developers to identify the total vacuum in database technology. The developer can find more database interview questions online or by buying one of the top recommend books for SQL interview preparation. Depending on the SQL flavor you're dealing with, take a look on MS SQL Server Interview Questions book or ORACLE PL/SQL Interview Questions book.