SQL Interview Questions - Mastek

1. Which type of join is used commercially?
a) Inner join b) outer join c) both d) None of these

2. Define 3NF form?

3. Explain the representation of Normalization?

4. Explain with syntax Natural, outer and right outer joins?

5. What are the different join algorithms?

6. What does SQL view means?

7. How to find out the database name in SQL*PLUS?

8. Which operator performs pattern matching?

a) % b) _ c) Both d) None of the above

9. How Oracle is different from SQL?