PEOPLE NAUKRI & CONSULTANCY Assistant Manager Interview Questions and Answers

Q1. Difference betwen joins
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• 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.

• Full Outer Join: Returns rows when there is a match in one ...read more
Answered by AI
Add your answer
Q2. Filter functions in DAX
Ans. 
Filter functions in DAX are used to manipulate data by applying filters based on specified conditions.
• FILTER function is used to return a table that contains only the rows that meet specified criteria.

• CALCULATE function is used to apply filters to a calculation.

• ALL function is used to remove filters from a column or table.

• RELATED function is used to retrieve related values from another table based on a specified relati
Answered by AI
Add your answer

Modelling water supply

Q1. HR will ask about ur job role in details, tennured work for the company and current salary
Add your answer

Q1. Question will be based on your work profile
Add your answer

Q1. 2nd round will be done and it will be refresher of previous round question with detailing
Add your answer

Q1. Knowledge check re obligation management
Add your answer

Q1. Introduction, Coding , SQL
Add your answer

Q1. What did you do in your previous org?
Add your answer
Q2. How did you help with hiring?
Add your answer

Q1. No comments it depends on the domain that you will be wory for
Add your answer
Q2. I cannot comment as it depends on the domain
Add your answer

Virtual English test

Q1. Questions around your technical knowledge
Add your answer

Q1. One-on-one round with head of Group
Add your answer