IQVIA Business Analyst Interview Questions and Answers

Agile ceremonies and Vlook up's demerit

• Agile ceremonies are regular meetings held in Agile methodology to ensure effective communication and collaboration among team members.

• Vlook up is a function in Excel used to search for a specific value in a table and return a corresponding value.

• The demerit of Vlook up is that it only searches for exact matches and cannot handle errors or inconsistencies in data.

• Agile ceremonies ...read more

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

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