Top 10 interview question on java and sql

Today i am providing here are top 10 questions which you have to be face , when you go for an interview in java, c and sql so be prepare for these questions because these can be ask from you while you going on interview

Top 10 SQL Questions

1) 

What is the difference between inner and outer join? Explain with example.

2)

What is the difference between JOIN and UNION?

3)

What is the difference between UNION and UNION ALL?

4)

What is the difference between WHERE clause and HAVING clause?

5)

What is the difference among UNION, MINUS and INTERSECT?

6)

What is Self Join and why is it required?

7)

How can we transpose a table using SQL (changing rows to column or vice-versa) ?

8)

How to select first 5 records from a table?

9)

What is the difference between ROWNUM pseudo column and ROW_NUMBER() function?

10)

What are the differences among ROWNUM, RANK and DENSE_RANK?

TOP 10 JAVA QUESTIONS

1 )

Is delete,next,main,exit or null keyword in java?

2)

Is Empty .java file name a valid source file name?

3)

What is classloader?

4)

What gives Java its 'write once and run anywhere' nature?

5)

What is the main difference between Java platform and other platforms?

6)

What is JIT compiler?

7)

How many types of memory areas are allocated by JVM?

8)

How many types of memory areas are allocated by JVM?

9)

What will be the problem if you don't override hashcode() method ?

10)

When do you override hashcode and equals() ?