Pratham Education Foundation Team Manager Interview Questions and Answers

Q1. What's your ctc
Ans. 
My current CTC is $80,000 per year.
• My current CTC is $80,000 per year

• I am open to discussing salary expectations during the interview process

• I have experience negotiating salary packages in previous roles
Answered by AI
Add your answer
Q2. Notice period negotiations
Add your answer

Write a pivot dinamic column from rows in SQL server.

Q1. Clustered and non clustered indexing in SQL server
Ans. 
Clustered indexing physically reorders the data in the table, while non-clustered indexing creates a separate structure.
• Clustered indexing determines the physical order of data rows in a table based on the indexed column.

• Non-clustered indexing creates a separate structure that contains the indexed column's values and pointers to the actual data rows.

• Clustered indexes are faster for retrieval but slower for inserts and ...read more
Answered by AI
Add your answer
Q2. Nested loops in SQL server
Ans. 
Nested loops in SQL server are used to iterate through multiple levels of data.
• Nested loops are used when you need to iterate through a set of data within another set of data.

• They can be implemented using nested SELECT statements or JOIN clauses.

• Example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id WHERE t1.column = 'value'
Answered by AI
Add your answer

Repository pattern in asp.net core API

Q1. Breif profile description
Ans. 
Experienced team manager with strong leadership skills and a proven track record of achieving team goals.
• Demonstrated ability to effectively communicate and motivate team members

• Proven experience in setting and achieving team targets

• Strong problem-solving and decision-making skills

• Excellent organizational and time management abilities

• Ability to handle conflicts and resolve issues within the team

• Experience in conducting...read more
Answered by AI
Add your answer
Q2. Expectation from NIIT
Ans. 
NIIT expects the Team Manager to have strong leadership skills, excellent communication abilities, and the ability to drive team performance.
• Strong leadership skills

• Excellent communication abilities

• Ability to drive team performance
Answered by AI
Add your answer
Q3. What new can you bring
Add your answer
Q4. Strong and weak points
Add your answer

Basic knowledge of aptitude

Q1. About my self nd my experience
Add your answer

Q1. What's your ctc
Ans. 
My current CTC is $80,000 per year.
• My current CTC is $80,000 per year

• I am open to discussing salary expectations during the interview process

• I have experience negotiating salary packages in previous roles
Answered by AI
Add your answer
Q2. Notice period negotiations
Add your answer

Q1. Why do you want to leave your current job
Add your answer
Q2. Why Would you join us
Add your answer

Q1. Understanding of edtech
Add your answer
Q2. Explain your cv in 3 lines
Add your answer