IQVIA Automation Engineer Interview Questions and Answers

Program to remove vowels from string array input by user

• Iterate through each string in the array

• For each string, iterate through each character and remove vowels

• Use a function to check if a character is a vowel (e.g. 'aeiouAEIOU')

Swap two values without using a third variable in a program

• Use bitwise XOR operation to swap two values without using a third variable

• Example: int a = 5, b = 10; a = a ^ b; b = a ^ b; a = a ^ b; // Now a = 10, b = 5

• Ensure the values are of the same data type for bitwise XOR operation to work correctly

I am comfortable with multiple programming languages, including Python, Java, and C++.

• Proficient in Python for automation scripting

• Experience with Java for backend development

• Knowledge of C++ for system programming

• Comfortable switching between languages based on project requirements

Joins are used to combine rows from two or more tables based on a related column between them.

• 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.

• 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 tabl...read more

To find the 2nd maximum salary from the employee table

• Order the salaries in descending order

• Use LIMIT 1,1 to get the second highest salary

Overloading is when multiple methods have the same name but different parameters, while overriding is when a subclass provides a specific implementation for a method in the superclass.

• Overloading involves multiple methods with the same name but different parameters

• Overriding involves a subclass providing a specific implementation for a method in the superclass

• Overloading is determined at compile time, while overriding is determined at runtime

CSS is a styling language used to design web pages, while Bootstrap is a front-end framework that helps in building responsive and mobile-first websites.

• CSS is a styling language used to control the look and feel of a website.

• Bootstrap is a front-end framework that provides pre-designed templates and components for building responsive websites.

• CSS requires manual coding for styling elements, while Bootstrap offers ready-to-use classes for styling.

• Bootstrap also includes JavaS...read more

REST API is a type of web service that allows communication between different systems over HTTP.

• REST stands for Representational State Transfer

• Uses standard HTTP methods like GET, POST, PUT, DELETE

• Data is transferred in JSON or XML format

• Stateless communication between client and server

• Example: Twitter API allows developers to access and interact with Twitter data