AstraZeneca Associate Engineer 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. About Yourself, strengths and weakness
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

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

Create charts, Excel formulas

Q1. Background and communication
Add your answer
Q2. Tell me about youe self
Add your answer

Q1. What about computer? Ans is my completed diploma in computer field
Add your answer
Q2. Which other courses done about computer? Ans is ms cit, tally, dtp, typing wpm(30-40)
Add your answer
Q3. All questions about computer field
Add your answer

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