IQVIA
10+ MNC Group Interview Questions and Answers
Q1. There are 2 cricket teams, A and B, with 11 players each. If every player of team A shakes hands with every player of team B(once), what will be the total number of handshakes?
Calculate the total number of handshakes between 2 cricket teams with 11 players each.
Use the formula n(n-1)/2 to calculate the number of handshakes for each team.
Multiply the result by the number of players in the other team.
Add the two results together to get the total number of handshakes.
Q2. There is a cricket team with 11 players. If every player in the team shakes hands with the other players once, what will be the total number of handshakes?
11 players in a cricket team shake hands with each other once. Find the total number of handshakes.
Each player shakes hands with 10 other players.
Total number of handshakes = 11C2 = 55
Formula for nC2 = n*(n-1)/2
Q3. How to use pivot in Excel and data grouping, coding knowledge
Using pivot and data grouping in Excel requires coding knowledge.
Select the data range to be pivoted
Go to Insert tab and click on PivotTable
Drag and drop fields into Rows, Columns, and Values
To group data, select the cells and right-click to select Group
Coding knowledge can be used to automate pivot creation and data grouping
Q4. data warehousing vs data lake? why is it useful
Data warehousing is structured and optimized for querying, while data lake is a more flexible storage solution for raw data.
Data warehousing involves storing structured data in a relational database for optimized querying.
Data lakes store raw, unstructured data in its native format for flexibility and scalability.
Data warehousing is useful for business intelligence and reporting, providing a structured and organized data repository.
Data lakes are useful for storing large volu...read more
Q5. What is Abstraction in oop
Abstraction is the process of hiding complex implementation details and showing only the necessary information to the user.
Abstraction is a fundamental concept in OOP
It helps in reducing complexity and increasing efficiency
It allows the user to focus on the essential features of an object
Examples include abstract classes, interfaces, and encapsulation
Q6. Concept of KNN and how to decide optimal N
KNN is a machine learning algorithm that classifies data points based on the majority class of its k-nearest neighbors.
KNN stands for K-Nearest Neighbors
It is a non-parametric and lazy learning algorithm
To decide the optimal value of N (number of neighbors), cross-validation techniques like Grid Search can be used
Choosing a small value of N can lead to overfitting, while a large value can lead to underfitting
Q7. How do you approach an HCP Segmentation Analysis
Approach HCP Segmentation Analysis by identifying key characteristics, grouping HCPs based on similarities, and analyzing each segment's needs.
Identify key characteristics such as specialty, prescribing behavior, geographic location, etc.
Group HCPs based on similarities in characteristics to create segments.
Analyze each segment's needs, preferences, and behaviors to tailor strategies accordingly.
Utilize data analytics tools and software to aid in segmentation analysis.
Regular...read more
Q8. Prime number using Java
A prime number is a number that is only divisible by 1 and itself.
Iterate through numbers from 2 to n-1
Check if n is divisible by any number in the range
If not, n is a prime number
Q9. Medical Writing Guidelines
Medical writing guidelines ensure accuracy, clarity, and consistency in medical documents.
Follow the guidelines set by regulatory bodies such as FDA and EMA
Use clear and concise language, avoiding jargon and technical terms
Ensure accuracy of data and references
Maintain consistency in formatting and style
Include appropriate disclosures and disclaimers
Examples: clinical study reports, regulatory submissions, patient information leaflets
Q10. List out linear regression Assumptions
Linear regression assumptions include linearity, independence, homoscedasticity, and normality.
Linearity: The relationship between the independent and dependent variables is linear.
Independence: The residuals are independent of each other.
Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.
Normality: The residuals are normally distributed.
No multicollinearity: The independent variables are not highly correlated with each ...read more
Q11. Challenges faced while doing automation
Challenges in automation include tool selection, maintenance, and handling dynamic elements.
Tool selection - choosing the right automation tool for the project requirements
Maintenance - keeping automation scripts up to date with application changes
Handling dynamic elements - dealing with elements on the page that change frequently
Data management - ensuring data integrity and accuracy in automated tests
Interview Process at MNC Group
Top Associate Consultant Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month