Bristol-Myers Squibb Interview Questions, Process, and Tips

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.

Q1. Brain teasers: after how many steps would a man fall into a pit who moves 2 step forward and 1 step backwards
Add your answer
Q2. Forecasting strategies
Add your answer

Q1. Be prepared with Pyspark and SQL
Add your answer
Q2. How to rename a column in pyspark
Ans. 
To rename a column in PySpark, use the 'withColumnRenamed' method.
• Use the 'withColumnRenamed' method on the DataFrame

• Specify the current column name and the new column name as arguments

• Assign the result to a new DataFrame to store the renamed column
Answered by AI
Add your answer
Q3. Difference between multiprocessing and multithreading
Ans. 
Multiprocessing involves executing multiple processes simultaneously, while multithreading involves executing multiple threads within a single process.
• Multiprocessing utilizes multiple CPUs or cores to execute multiple processes concurrently.

• Multithreading involves creating multiple threads within a single process to execute tasks concurrently.

• Processes in multiprocessing have separate memory spaces, while threads in m...read more
Answered by AI
Add your answer
Q4. Which one to use when
Add your answer

Q1. Application development
Add your answer
Q2. React native basics
Add your answer

Airwatvh production deployment

Q1. Salary negotiations
Add your answer
Q2. Bonus discussion
Add your answer

Q1. Technical questions based on your stream
Add your answer

Q1. Technical questions based on the app
Add your answer