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?

Question

Accepted Answer

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 materialized views
4. Difference between procedure and functions
5. Can we call procedure inside functions
6. Constraints and its types
7. Triggers and its types
8. Can we recover the data after truncate
9. What is foreign key
10. Cursors and its types
11. Write a procedure to calculate the number of experience of each employee
12. Date functions in Oracle
13. Collection types in Oracle and their differences
14. Bulk collection
15. Can we use commit inside a trigger
16. Difference between row level and statement level trigger
17. Pragma in Oracle
18. Difference between union set operator and union all
19. Performance tuning related questions
20. Identifying and optimizing slow-running queries
21. Difference between Group by and having clause
22. Rank(), dense_rank(), and row_number() analytical functions and their differences
23. Advantages of packages
24. How packages improve database performance
25. Query to find department-wise total salary
26. Query to count specified characters from a given string
27. Query to find employees earning more than Chetan
28. Types of subqueries
29. Exists and not exists operators in correlated subqueries

Top LTIMindtree Senior Consultant interview questions & answers

Popular interview questions of Senior Consultant

Top HR questions asked in LTIMindtree Senior Consultant