MSD Pharmaceuticals Data Analyst Intern Interview Questions and Answers

Q1. Using sql extract substring of name
Ans. 
Using SQL to extract substring of name
• Use the SUBSTRING function in SQL to extract a specific portion of a string

• Specify the starting position and length of the substring to be extracted

• Example: SELECT SUBSTRING('John Doe', 1, 4) AS First_Name will return 'John'
Answered by AI
Add your answer
Q2. Using sql print cummulative sum of sales
Ans. 
Use SQL to print cumulative sum of sales
• Use the SUM() function to calculate the cumulative sum of sales

• Utilize the OVER() clause with ORDER BY to specify the order of the cumulative sum

• Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS cumulative_sales FROM table_name
Answered by AI
Add your answer

Multiple choice questions

Q1. Scenario based questions
Add your answer

Q1. Salary discussion
Add your answer

Q1. About remote work willingness
Add your answer
Q2. Salary expectation
Add your answer

Tell me about your recent project

Mathematics and logical reasoning.

Q1. Why do u want to join roche
Add your answer
Q2. How data science plays vital roles in contemporary world
Ans. 
Data science plays vital roles in contemporary world by enabling businesses to make data-driven decisions, improving healthcare outcomes, enhancing customer experiences, and driving innovation.
• Data science helps businesses make informed decisions by analyzing large datasets to identify trends and patterns.

• In healthcare, data science is used to predict disease outbreaks, personalize treatment plans, and improve patient ...read more
Answered by AI
Add your answer

Q1. Tell me about yourself How was last experience Data concepts basics
Add your answer
Q2. Checking confidence, fluent English, listening carefully
Add your answer

17 questions including mcq, case study, sql coding

Q1. 10 quiz about ML questions, case study
Add your answer