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!
Select
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?
LTIMindtree Senior Consultant Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
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

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits