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?

AnswerBot
1y
This is a list of interview questions for a Senior Consultant position.
1. Roles and responsibilities in current project
2. Difference between Delete and truncate
3. Difference between view and materiali...read more
Help your peers!
Add answer anonymously...
LTIMindtree Senior Consultant interview questions & answers
A Senior Consultant was asked 5mo agoQ. What is a plugin pipeline?
A Senior Consultant was asked 6mo agoQ. Describe the detailed implementation process of forms in Express 3.
A Senior Consultant was asked 6mo agoQ. Explain the detailed implementation of Express3 pages.
Popular interview questions of Senior Consultant
A Senior Consultant was asked 5mo agoQ1. What is a plugin pipeline?
A Senior Consultant was asked 6mo agoQ2. Describe the detailed implementation process of forms in Express 3.
A Senior Consultant was asked 6mo agoQ3. Explain the detailed implementation of Express3 pages.
Top HR questions asked in LTIMindtree Senior Consultant
A Senior Consultant was asked 5mo agoQ1. Do you have any preferred work locations?
A Senior Consultant was asked 5mo agoQ2. Where do you see yourself in the next 5 years?
A Senior Consultant was asked 9mo agoQ3. Why do you want to work with LTIMINDTREE?
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

