Consultant Interview Questions

188,115 consultant interview questions shared by candidates

1. Write an SQL to get 2nd highest salary of an employee. 2. What is difference between webserver and application server? 3. Difference between get and load in hibernate. 4. How will you handle in java if out of million records only half is moved and the process fails? 5. What is spring batch? 6. What is joint point and point cut? 7. Tell me about yourself 8. Tell me about your project architecture 9. Create an entity in Hibernate 10. Write code for one to many and one to one mapping. 11. It will compile/execute or not, public static void main(Str[] args) If remove public If remove static if replaced void with int If replace Str[] args to String… If renamed main to abc 12. How to do Spring and Hibernate integration, write all the configuration file changes and annotations used. 13. What is the purpose of @Component, @Controller, @Service, @DAO. 14. Design an architecture for a ecommerce website from web.xml to designing a table in DB. How the flow will be from getting a request till persisting a data in DB. 15. How do dispatcher servlet know which spring config file needs to be called. 16. How in one to many mapping Hibernate knows on which column mapping has to be done. 17. Example of OneToMany mapping and write code. 18. What is immutable, write a code to convert a user define object to immutable. 19. What is HashMap, how it functions? 20. How hashcode defines at what location key-value pair needs to be saved. 21. If I override hashcode method and return an int value where the key-value pair will be saved? 22. I have 2 class Emp1 and Emp2 with properties such as Id, Salary, Name, Department. I want to sort the array consisting of these objects based on salary of Employee present in these 2 class. Write a code to do so. 23. I have a class with variables a=1, b=2, c=3 I want to move this class from one JVM to another JVM but the value should be a=1, b=0, c=3. How to achieve this.
avatar

Consultant

Interviewed at Deloitte

3.8
May 7, 2017

1. Write an SQL to get 2nd highest salary of an employee. 2. What is difference between webserver and application server? 3. Difference between get and load in hibernate. 4. How will you handle in java if out of million records only half is moved and the process fails? 5. What is spring batch? 6. What is joint point and point cut? 7. Tell me about yourself 8. Tell me about your project architecture 9. Create an entity in Hibernate 10. Write code for one to many and one to one mapping. 11. It will compile/execute or not, public static void main(Str[] args) If remove public If remove static if replaced void with int If replace Str[] args to String… If renamed main to abc 12. How to do Spring and Hibernate integration, write all the configuration file changes and annotations used. 13. What is the purpose of @Component, @Controller, @Service, @DAO. 14. Design an architecture for a ecommerce website from web.xml to designing a table in DB. How the flow will be from getting a request till persisting a data in DB. 15. How do dispatcher servlet know which spring config file needs to be called. 16. How in one to many mapping Hibernate knows on which column mapping has to be done. 17. Example of OneToMany mapping and write code. 18. What is immutable, write a code to convert a user define object to immutable. 19. What is HashMap, how it functions? 20. How hashcode defines at what location key-value pair needs to be saved. 21. If I override hashcode method and return an int value where the key-value pair will be saved? 22. I have 2 class Emp1 and Emp2 with properties such as Id, Salary, Name, Department. I want to sort the array consisting of these objects based on salary of Employee present in these 2 class. Write a code to do so. 23. I have a class with variables a=1, b=2, c=3 I want to move this class from one JVM to another JVM but the value should be a=1, b=0, c=3. How to achieve this.

Viewing 1001 - 1010 interview questions

Glassdoor has 188,115 interview questions and reports from Consultant interviews. Prepare for your interview. Get hired. Love your job.