Eli Lilly and Company Senior Associate Manager 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

Q1. Production related
Add your answer
Q2. Document wise related
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