Hexaware Technologies AST 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

Q1. Why you prefer this job role
Ans. 
I prefer this job role because of the opportunity to work with a variety of clients and industries, utilizing my problem-solving skills.
• Opportunity to work with diverse clients and industries

• Utilizing problem-solving skills

• Enjoy the challenge of finding solutions for different scenarios
Answered by AI
Add your answer
Q2. Good with night shift?
Ans. 
Yes, I am comfortable with night shifts and have experience working during those hours.
• I have previous experience working night shifts in my previous job.

• I am able to adjust my sleep schedule to accommodate working at night.

• I understand the importance of being alert and focused during night shifts.

• I am willing to work night shifts as needed to support the team.
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Good with night shift
Add your answer

Q1. Azure ad connect components
Add your answer
Q2. Authentication protocol
Add your answer
Q3. Metaverse explaination
Add your answer
Q4. Application integration
Add your answer
Q5. Scim provisioning
Add your answer
Q6. Conditional access
Add your answer
Q7. Privileged identity management
Add your answer

Q1. Terraform questions related ones
Add your answer
Q2. Devops coding and data engg
Add your answer

Q1. Explain your key projects
Add your answer
Q2. Why nagarro? Why this practice?
Add your answer

Q1. Js and React js question
Add your answer
Q2. Releted to js and React
Add your answer

Q1. Why you want to join IGT ?
Ans. 
I want to join IGT because of its reputation for providing top-notch travel services and opportunities for professional growth.
• IGT is known for its excellent customer service and innovative travel solutions

• I am impressed by IGT's commitment to employee development and training programs

• I believe that working at IGT will allow me to expand my knowledge and skills in the travel industry
Answered by AI
Add your answer
Q2. Why you left your previous company?
Ans. 
Seeking new opportunities for growth and development.
• Looking for new challenges and opportunities to expand my skills

• Desire for career advancement and professional growth

• Company restructuring led to changes in job responsibilities
Answered by AI
Add your answer

Versant was conducted

Q1. Where you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a senior travel consultant leading a team of experts, expanding our client base, and exploring new destinations.
• Leading a team of travel consultants

• Expanding client base through exceptional service

• Exploring new destinations and creating unique travel experiences
Answered by AI
Add your answer
Q2. Are you confortable with night shifts
Ans. 
Yes, I am comfortable with night shifts as I am able to adapt my schedule and prioritize my work effectively.
• I have previous experience working night shifts in a customer service role.

• I am a night owl and tend to be more productive during nighttime hours.

• I understand the importance of being alert and focused during night shifts to provide excellent service to clients.
Answered by AI
Add your answer

Q1. Tell me the sap journey
Ans. 
The SAP journey involves implementing, customizing, and optimizing SAP software to meet business needs.
• Start with understanding the business requirements and goals

• Implement SAP software modules based on the requirements

• Customize the software to fit the specific needs of the organization

• Optimize the system for efficiency and effectiveness

• Provide training and support to users for successful adoption
Answered by AI
Add your answer
Q2. Subcontracting process
Add your answer
Q3. Consignment process
Add your answer

Q1. Salary expectations
Add your answer