Blenheim Chalcot Assistant Manager- HR Interview Questions and Answers

Q1. Sql joins and types of joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• F...read more
Answered by AI
Add your answer
Q2. Powerbi and done projects
Add your answer

Q1. Question related to FEM,
Add your answer
Q2. Questions related to SOM, Projects, basic of coding etc
Add your answer

Commands of docker, git

Q1. Commands of Git
Add your answer

Coding based on basic DSA algorithms

25 MCQ questions 20 min

It was conducted through hackerrank platform which contains 5 programming questions

There were 3 sections

Q1. How can Analytics be used in HR?
Ans. 
Analytics in HR enhances decision-making, improves employee engagement, and optimizes talent management through data-driven insights.
• Predictive analytics can forecast employee turnover, allowing HR to implement retention strategies.

• Performance analytics can identify high-performing employees and inform succession planning.

• Sentiment analysis of employee feedback can help improve workplace culture and engagement.

• Recruitm...read more
Answered by AI
Add your answer
Q2. Importance of Data in todays world
Add your answer

String programs and oops consepts were asked in the interview

Q1. Find dynamic xpath to find elemeny
Ans. 
Dynamic xpath can be found using various methods like contains, starts-with, and ends-with.
• Use contains() function to find an element with a partial match in its attribute value

• Use starts-with() function to find an element with a match at the beginning of its attribute value

• Use ends-with() function to find an element with a match at the end of its attribute value

• Use variables to make the xpath dynamic and reusable

• Use p...read more
Answered by AI
Add your answer
Q2. Find string convert and find special characters
Ans. 
To find and convert a string while also identifying special characters.
• Use string methods like replace() or regex to find and convert the string.

• To identify special characters, use regex to match against a list of known special characters.

• Consider using a library like Python's re module for more advanced regex matching.
Answered by AI
Add your answer

Q1. Roles and Responsibilities
Add your answer
Q2. Exlpain your current project
Add your answer