Database Interview Series 6

Database Interview Series 6

This is common question which interview ask in interview for Java Developer or Sr. Java Developer position:

1. Can you write a query which return 4th max record from the table

2. Can you write a query which will return only even value from the table using Oracle rownum

3. What is unique index

4. How find maximum record from table

5. How you find 2nd maximum record from table

6. We have table Employee with column: EmpID,name and table Department column: EmpID,location and mapping table EmpDept with column: EmpID,add_id which is reference of employee and person table. How you will join two table and get data can write SQL query

7. Write query on two table to find sum of salary

 

Leave a Reply

Your email address will not be published. Required fields are marked *

I am not Robot *