10+ IQVIA Interview Questions and Answers

Procedures and functions are stored routines in a database that can be called to perform specific tasks.

• Procedures are a set of SQL statements that perform a specific task. They can have input and output parameters.

• Functions are similar to procedures but return a value. They can be used in SQL queries like any other function.

• Both procedures and functions can improve code reusability and maintainability in a database system.

Sort array of strings based on custom logic

• Define the custom logic for sorting

• Implement a sorting algorithm such as bubble sort or quicksort

• Apply the custom logic during the sorting process

Abstraction is hiding the implementation details while interface is a contract that defines the methods that a class must implement.

• Abstraction focuses on hiding the internal implementation details of a class, allowing the user to only see the necessary information.

• Interfaces define a set of methods that a class must implement, without specifying how those methods are implemented.

• Abstraction can be achieved through abstract classes in object-oriented programming languages.

• Int...read more

String is immutable in order to ensure data integrity and security.

• Immutable strings prevent accidental changes to data, ensuring consistency in programs.

• Immutable strings allow for more efficient memory management and optimization.

• Example: In Java, once a string object is created, its value cannot be changed.

Check if a string is a palindrome or not.

• Reverse the string and compare it with the original string.

• Use two pointers, one at the beginning and one at the end, and compare the characters.

• Ignore non-alphanumeric characters and convert to lowercase before checking.

Extrusion is a process used to create objects of a fixed cross-sectional profile.

• Extrusion is a manufacturing process where a material is pushed through a die to create a specific shape.

• Common materials used in extrusion include metals, plastics, and food products.

• Examples of extruded products include pipes, rods, and window frames.

Primary key is a unique identifier for each record in a database table.

• Primary key ensures each record in a table is uniquely identified.

• It must have a unique value for each record.

• Primary key can be a single column or a combination of columns.

• Examples: ID column in a user table, combination of first name and last name in an employee table.

A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.

• Triggers are used to maintain data integrity by enforcing business rules or cascading changes.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations.

• Examples include auditing changes to a table, updating related records in other tables, or enforcing constraints.

A database is a structured collection of data that is stored and accessed electronically.

• Database organizes and stores data in tables

• It allows for efficient retrieval, insertion, and updating of data

• Examples include MySQL, Oracle, MongoDB

Middleware in .NET Core is a component that can handle requests and responses in the application pipeline.

• Middleware is a piece of software that can intercept and process HTTP requests and responses in the application pipeline.

• Middleware can be used for logging, authentication, authorization, error handling, and more.

• Middleware is added to the application pipeline using the app.UseMiddleware() method in the Configure method of the Startup class.

• Example: app.UseMiddleware<Cust...read more