Header Ads Widget

SQL Interview Questions Deloitte

If you are looking for SQL interview questions, then my dear friends you are on right page. This blog is about sharing SQL interview questions and interview experiences. Today's post is based on my personal experience about Deloitte SQL interview questions.

SQL Interview Questions Deloitte
I am working on Oracle Retail applications, so I use SQL, PL/SQL, UNIX in day to day work. On the day of interview they had 3 person in panel and their first question was as usual, how much IT experience do you have and then what is your relevant experience in SQL ?

There comes the most dangerous and tricky question, "Rate yourself on the scale of 10 in SQL."
If you are very good in SQL then also you should say 6 to 7. If you are saying 8 or 9 then you will be screwed up and rejected. It will set up expectation in their mind and if you are not answering as per the standard of 8-9, you will be rejected.

So always say 6 to 7 and be in a safe zone. Now they started asking back to back questions:

Q. What is view ?

Q. What are different types of View ?

Q. What is materialized view and how it is different from normal view ?

Q. If you are saying materialized view is a exact copy of data set then can you tell me how can we refresh it ?

Q. What are the disadvantages and advantage of using materialized view ?

Q. Have you used triggers ever ? If yes then can you list down some advantages of using it ?

Q. Can you list down types of triggers ?

Q. Can we use triggers on Views ? If yes then how ?

Q. Have you ever encountered a scenario,  let's say when you are updating the table and that table has one 'after trigger' which updates same table ?

Q. Do you know what is mutating table/trigger ?

Q. How can we handle mutating table/trigger?

Q. When we use 'IN' clause and 'EXISTS' clause ?

Q. Which is faster among them and why ?

Q. Can you share any challenging situation you have faced ?

Q. What to do if I have millions of records to fetch in select from a table and it is taking long time ?

Q. What is index on a table ?

Q. What are the disadvantages of creating an index on table ?

Q. Difference between CASE and DECODE.

These were the questions asked to me and then they switched to PL/SQL.
I will share PL/SQL questions in next post. I hope you have got some information and it will help you in preparing for interview.





Post a Comment

1 Comments

  1. Thank you for providing real time questions. It will be helpful if you can provide some answers also.

    ReplyDelete

Please wait, we will address your query shortly