1. Roles and responsibilities in current project? 2. Difference between Delete and truncate? 3. Difference between view and materialized views? 4.Difference between procedure and functions? 5. Can we call procedure inside functions? 6. Constraints and it's types? 7. Triggers and it's types? 8. Can we recover the data after truncate? 9.what is foreign key? 10. Cursors and it's types? 11. Write a procedure to calculate nu.of experience of each employees? 12. Which are date functions which you know? 13. What are the collection types in Oracle? And differentiate it 14. What is bulk collection 15. Can we use commit inside trigger? 16. What is difference between row level and statement level trigger 17. What is pragma in Oracle? 18. How union set operator is different than union all? 19. Performance tuning related questions 20. How will you identify whether query is taking too much time for execution and how to optimise running queries? 21. Difference between Group by and having clause? 22. What is rank(),dense_rank() and row_number() analytical functions and they are differ by their functionality? 23. What are main advantages of packages? 24. How packages improves the performance of database? 25. Write a query to find department wise total salary? 26. Write a query to count only specified characters from given string String: GOOGLE Total nu of "O" from GOOGLE 27. Write a query to find who is more earning than Chetan from employees table 28. Which are the types of subquery? 29. What is exists and not exists operator in correlated subquery?