Bristol-Myers Squibb Interview Questions, Process, and Tips for Experienced

Q1. How Javascript works
Ans. 
JavaScript is a scripting language that allows for dynamic content and interactivity on websites.
• JavaScript is a client-side scripting language used for web development.

• It can be embedded directly into HTML pages.

• JavaScript code is executed by the browser on the client side.

• It can manipulate the DOM, handle events, and interact with server-side scripts.

• Commonly used frameworks/libraries include React, Angular, and Vue.
Answered by AI
Add your answer

Q1. Make an application using react
Ans. 
Create a React application for a specific purpose or functionality.
• Use create-react-app to set up a new React project

• Design components using JSX syntax

• Manage state and props to pass data between components

• Utilize React Router for navigation between different pages

• Fetch data from an API using Axios or Fetch for dynamic content
Answered by AI
Add your answer

Questions on pyspark, SQL, AWS and Python

Pyspark, SQL, python and AWS

Q1. How you handled a challenging task
Ans. Provide a real life case scenario and discuss on how you handled it.
Answered Anonymously
Add your answer
Q2. Describe a situation where you had to work beyond your expectations
Add your answer

Q1. How did you manage to handle criticism while maintaining your composure?
Add your answer
Q2. How did you prioritize your work based on urgency?
Add your answer

Q1. Find distinct without distinct keyword in SQL
Ans. 
Use GROUP BY to find distinct values in SQL without using the DISTINCT keyword.
• Use GROUP BY clause with all columns in the SELECT statement

• This will group the rows with the same values together, effectively giving distinct values
Answered by AI
Add your answer
Q2. Concat 3 columns and handle when null: select concat(a, b, c) from table
Ans. 
Concatenate 3 columns and handle null values in SQL query
• Use CONCAT_WS function to concatenate columns and handle null values

• Provide a separator as the first argument in CONCAT_WS function

• Use IFNULL function to replace null values with a specified value
Answered by AI
Add your answer

Interview with VP. They ask a variety of questions including current role, future aspirations, people orientation, ethics etc.