Indira Gandhi Institute of Development Research Interview Questions and Answers

Art related assignment

Q1. How you spend your day?
Add your answer
Q2. Inauguration of Ram Mandir in Ayodhya?
Add your answer
Q3. About your Job role?
Add your answer

Q1. Different types of Join and What is self join
Ans. 
Different types of joins include inner join, outer join, left join, and right join. Self join is when a table is joined with itself.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the 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 row...read more
Answered by AI
Add your answer
Q2. What is View and there practicle use
Ans. 
A view is a virtual table created by a query. It can be used to simplify complex queries, provide security, and improve performance.
• Views can hide complexity by encapsulating multiple tables into a single virtual table.

• Views can restrict access to certain columns or rows, providing security.

• Views can improve performance by pre-computing joins or aggregations.

• Example: CREATE VIEW vw_employee AS SELECT emp_id, emp_name F
Answered by AI
Add your answer

Q1. Questions about my college project and technologies used
Add your answer
Q2. Optimization process of SQL Query
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, and avoiding unnecessary joins.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using subqueries or temporary tables
Answered by AI
Add your answer

Q1. What would I bring to the team
Ans. 
I would bring creativity, enthusiasm, and a passion for student success to the team as a Primary Teacher.
• I have a strong background in creating engaging lesson plans and activities to keep students motivated and excited about learning.

• I am dedicated to fostering a positive and inclusive classroom environment where all students feel valued and supported.

• I have experience in differentiating instruction to meet the divers...read more
Answered by AI
Add your answer
Q2. Tell us about yourself and why you want to make the move
Add your answer

Q1. Why should we hire someone as "young" as you for a serious role such as this?
Ans. 
You should hire me for my fresh perspective, innovative ideas, and ability to adapt quickly to new technologies and trends.
• Younger individuals often bring fresh perspectives and innovative ideas to the table.

• I am quick to adapt to new technologies and trends, which is crucial in a fast-paced field like Learning & Development.

• My energy and enthusiasm can inspire and motivate the team to achieve their goals.

• I have a stro...read more
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a dedicated and detail-oriented individual with a passion for research and a strong academic background in [specific field].
• Graduated with a degree in [specific field]

• Experience conducting research projects

• Strong analytical and critical thinking skills

• Passionate about contributing to the field of [specific field]
Answered by AI
Add your answer
Q2. Why do you want to do this job?
Ans. 
I am passionate about conducting research and contributing to the advancement of knowledge in this field.
• Passionate about conducting research

• Desire to contribute to the advancement of knowledge

• Interest in the specific field of research
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Expertise in which subject
Add your answer
Q3. Give demo on any subject which I am comfortable to teach
Add your answer
Q4. Question and answer in demo subject
Add your answer

Q1. What are my qualification and achievements
Add your answer
Q2. All documents are verified
Add your answer

Q1. Salary expectation
Add your answer
Q2. In how many I can join the institute
Add your answer

Q1. About your self
Add your answer
Q2. Experience and salary
Add your answer

Q1. About your self
Add your answer
Q2. Experience and salary
Add your answer

Q1. Tell me About urself
Add your answer
Q2. Why u are fit for the school
Add your answer