ADL Supplier Business Analyst Interview Questions and Answers

Q1. Outcome of joins
Ans. 
Joins in SQL combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of joins include 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.

• R...read more
Answered by AI
Add your answer
Q2. Types of joins in sql
Ans. 
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
• 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 rows from the left table

• Full join: Returns r
Answered by AI
Add your answer

Q1. Tell me your educational background
Add your answer

Q1. Explain which methodology you use for Process mapping documentation
Ans. 
I use the BPMN (Business Process Model and Notation) methodology for process mapping documentation.
• BPMN is a widely accepted standard for process modeling and documentation.

• It provides a graphical representation of processes using various symbols and notations.

• BPMN allows for clear visualization of process flows, activities, decisions, and interactions.

• It helps in identifying bottlenecks, inefficiencies, and areas for ...read more
Answered by AI
Add your answer

The questions are fundamental and straightforward.

Q1. Two coding questions and questions are related to sorting algorithm and if else loop
Add your answer

Q1. Basic questions related to resume and some questions related to my electrical engineering stream why did I choose to join an it company
Add your answer

Q1. Self introduction
Add your answer

Q1. Detail understanding of BA knowhow
Add your answer
Q2. Managerial round was more about how fit you are for this role.
Add your answer

Group discussion for 30 mins, AI

Q1. Did not clear the gd
Add your answer
Q2. Was not able to clear the gd
Add your answer