Pratham Education Foundation Associate Interview Questions and Answers

Q1. Tell me something about yourself?
Add your answer

Q1. Casual questions
Add your answer
Q2. He doesn't know what to ask question, he was blank at the time of interview. Venkatesh Chhapri.
Add your answer

General reasoning but needs a little extra effort to complete.

Q1. Self Intro, Previous roles and responsibilities explanation. Explaining practical scenarios. Examples of issues and resolution steps.
Add your answer

Q1. Basic details to explain about organisation and roles and responsibilities they are expected to do
Add your answer

Q1. Personal and professional work experiance.
Add your answer
Q2. About our key areas. Arr we good with communications. Sales knowledge.
Add your answer

I'm trusting me I will pass this interview

Q1. Tell me About Yourself
Add your answer
Q2. Be confident and just share your experiences and hobbies...
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. Why do you want to leave your current job
Add your answer
Q2. Why Would you join us
Ans. 
I am drawn to your organization for its innovative approach, strong values, and commitment to professional growth.
• Your company's reputation for innovation aligns with my passion for creative problem-solving, as seen in my previous project where I implemented a new workflow that increased efficiency by 30%.

• I admire your commitment to employee development, which resonates with my belief in continuous learning; I have led...read more
Answered by AI
Add your answer

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