Merck Group Interview Questions, Process, and Tips

Q1. Difference between all union all distinct
Ans. 
ALL returns all rows, UNION removes duplicates, DISTINCT returns unique rows.
• ALL: includes all rows, even duplicates

• UNION: combines two result sets and removes duplicates

• DISTINCT: returns only unique rows

• Example: SELECT name FROM table1 UNION SELECT name FROM table2;

• Example: SELECT name FROM table1 UNION ALL SELECT name FROM table2;

• Example: SELECT DISTINCT name FROM table1;
Answered by AI
Add your answer
Q2. Convert the given dictionary to list and sort dictionary in ascending order
Ans. 
Convert dictionary to list and sort in ascending order
• Use the items() method to convert dictionary to list of tuples

• Use the sorted() function to sort the list of tuples

• Use a lambda function to sort by dictionary values

• Convert the sorted list of tuples back to a dictionary using dict() method
Answered by AI
Add your answer

Easy aptitude test which you can copy paste easily from google, they have 25 questions for the last 2 years.

Q1. Just learn the basics and If you're referred from someone then you don't have to worry.
Add your answer
Q2. Intro Basic OOP questions. Basic arrays, string questions. Interview Tip :- Brush up the basics. Just be confident, sometimes even interviewer don't know what he is asking.
Add your answer
Q3. Some basic programming questions
Add your answer
Q4. Explain your final year project in brief
Add your answer

Q1. Just google HR round questions and Boom now you're a part of self claimed Product based company.
Add your answer
Q2. What will be the strategy to work in our company
Add your answer
Q3. What are your strengths and weakness
Add your answer

Q1. There will be genral questions
Add your answer
Q2. General questions .......
Add your answer

Q1. About your experience
Add your answer
Q2. Process releted questions
Add your answer

Q1. Joined as fresher so, they asked about college project , asked `basic coding question? basic java.
Add your answer
Q2. Asked some scenario based question.
Add your answer