Database Interview Series 5
This database question was asked for Sr. Software developer position in Morgan Stanley New York location. It was java middle-ware with the knowledge of writing query, procedure, functions,triggers etc…
1. What is explain plan in database
2. Can you write a query which return 4th max record from the table
3. Can you write a query which will return only even value from the table using Oracle rownum
4. What is difference between Procedure and function
5. What is trigger how many types of trigger are there
6. How do you know what type of trigger it is
7. Can you write query which will pull employee got 2nd highest salary
8. What is difference between clustered and non-clustered index and how you create it
9. What is difference between primary key and unique key
