DevNatives interview questions

Handling uncaught Errors in code base

1. What is the difference between WHERE and HAVING Clause? And when we use where or Having explain with an example? 2. Write a query to find 3rd Maximum salary ? (Easy one) 3. Explain Normalization Types? 4. What is the difference between OLAP and OLTP? 5. Interviewer Provide me a scenario for query writing, I think it was like " Find those employees whos Average salary is greater than 100k department wise" 6. What is the difference between Union and Union ALL? 7. What is the difference between Delete and Truncate statement? 8. Difference between Fact and Dimensions? 9. Different type of Joins? 10. Types of SCD with Example?