Eli Lilly and Company Senior Associate Interview Questions and Answers

Q1. How many types of joins in sql
Ans. 
There are four types of joins in SQL: 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.

• FULL JOIN: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer
Q2. Diff between list and set
Ans. 
List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.
• List maintains the order of elements, while set does not guarantee any specific order.

• List allows duplicate elements, while set does not allow duplicates.

• List is implemented using classes like ArrayList, LinkedList, etc., while set is implemented using classes like HashSet, TreeSet, etc.
Answered by AI
Add your answer
Q3. Diff between map set
Ans. 
Map is a collection of key-value pairs where each key is unique, while a set is a collection of unique elements with no duplicate values.
• Map allows duplicate values but keys must be unique, while set does not allow duplicates.

• Map is accessed using keys, while set is accessed using elements.

• Example: Map - {1: 'apple', 2: 'banana'}, Set - {'apple', 'banana'}
Answered by AI
Add your answer
Q4. Write Fibonacci program
Ans. 
Fibonacci program generates the Fibonacci sequence up to a specified number of terms.
• Start with two variables initialized to 0 and 1

• Use a loop to calculate the next Fibonacci number by adding the previous two numbers

• Repeat the process until the desired number of terms is reached
Answered by AI
Add your answer

My self yerravally Rakesh Goud.
My graduation bsc biotechnology in osmania university my inter Geetanjali junior college.qnd SCC ZPHS in nemtoor

My self yerravally Rakesh Goud.im came from Telangana district and my education background i studied at osmania university bsc biotechnology and intermediate Geethanjali junior college and my ssc ZPHS nemtoor current working in Sanofi Healthcare Pvt Ltd india

Dynamic programming and arrays

Q1. Resume based questions, discussion on projects and dsa questions
Add your answer

It's was based on vigilance

Q1. How do u manage ur work and life
Add your answer

About aptitude and core related such as mass heat and fluid operations

Q1. Why you want to place in this job
Ans. 
I am interested in this job because it aligns with my skills and interests in process management.
• I have a strong background in process management and have successfully implemented process improvements in my previous roles.

• I am highly organized and detail-oriented, which are essential skills for a Process Associate.

• I enjoy analyzing data and identifying areas for improvement in processes.

• I am motivated by the opportunit...read more
Answered by AI
Add your answer
Q2. What are you future plans after hiring you
Ans. 
I plan to grow within the company and take on more responsibilities.
• I aim to develop my skills and knowledge in the process associate role.

• I would like to take on additional tasks and projects to contribute more to the team.

• I hope to build strong relationships with colleagues and learn from their expertise.

• I am open to opportunities for advancement and promotion within the company.

• I will actively seek feedback and work...read more
Answered by AI
Add your answer

Q1. Details on the projects you have worked
Ans. 
I have worked on various projects including web development, data analysis, and software testing.
• Web development: Created a responsive website using HTML, CSS, and JavaScript.

• Data analysis: Analyzed customer data to identify trends and make recommendations for marketing strategies.

• Software testing: Conducted thorough testing of a mobile application to ensure functionality and usability.

• Project management: Led a team of...read more
Answered by AI
Add your answer

Q1. How to handle the project, explain stepwise
Ans. 
To handle a project, follow these steps
• Define project goals and objectives

• Create a project plan with tasks, timelines, and resources

• Assign tasks to team members and set deadlines

• Monitor progress and make necessary adjustments

• Communicate regularly with stakeholders

• Manage risks and resolve issues

• Test and evaluate project deliverables

• Complete the project and conduct a post-project review
Answered by AI
Add your answer

Q1. Regarding ALCOA principles,filter integrity, Area and equipment qualifications, media fill
Add your answer