Hexaware Technologies Associate Consultant Interview Questions and Answers

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

A 60-minute aptitude test.

In this round, you will receive multiple questions tailored to your area of expertise.

Q1. What motivated you to pursue a career in UI/UX design?
Add your answer
Q2. Could you please showcase your previous work experiences?
Add your answer

Q1. Why Bosch? Ans: As bosch files 20 patents per day, thus innovation is what drives the organization and I want to be the part of it.
Ans. 
Bosch's focus on innovation and high number of patents filed daily make it an exciting and dynamic place to work.
• Bosch's commitment to innovation is evident in their filing of 20 patents per day

• I am drawn to the opportunity to be part of a company that values creativity and forward thinking

• The chance to contribute to cutting-edge technology and solutions is a major attraction of working at Bosch
Answered by AI
Add your answer

Q1. Subject Related Interview Questions
Add your answer

Q1. Subject related interview questions
Add your answer

Q1. Salary and other discussions
Add your answer

Q1. Subject related interview questions
Add your answer

Apptitude test comprising of technical questions on Data networks, DBMS , Programming Language etc

Q1. Questions were on AD and Windows
Add your answer

Q1. Formal HR Interview questions
Add your answer

Q1. Questions related to javascript/HTML
Add your answer
Q2. Question related angular framework
Add your answer

Q1. Advance angular question
Add your answer
Q2. Advance js question
Add your answer

Q1. Behavioral question
Add your answer
Q2. About experience
Add your answer

Q1. Sliding window problem
Ans. 
Sliding window technique is used to solve problems involving subarrays or substrings by creating a window that can expand and contract based on certain conditions.
• Maintain start and end indices to represent current window

• Adjust indices based on problem constraints

• Minimize number of elements processed for optimized performance
Answered by AI
Add your answer
Q2. How do you handle stress
Ans. 
I handle stress by practicing mindfulness, taking breaks, and seeking support from colleagues.
• Practice mindfulness techniques such as deep breathing or meditation

• Take short breaks throughout the day to recharge

• Seek support from colleagues or a mentor to talk through challenges

• Exercise regularly to reduce stress levels

• Maintain a healthy work-life balance
Answered by AI
Add your answer