Philips Innovation Campus Mechanical Engineer Interview Questions and Answers

Q1. What is the use of button when link can submit the form?
Ans. 
Buttons are used for actions within the form, while links are used for navigation.
• Buttons can trigger JavaScript functions or perform form validation before submission

• Buttons can have different styles and behaviors compared to links

• Buttons are more accessible for users with disabilities
Answered by AI
View 1 more answer

Q1. How do you optimize a SQL procedure with 5000 lines in code?
Ans. 
Optimize a SQL procedure with 5000 lines of code by identifying bottlenecks and implementing performance improvements.
• Identify and analyze the most time-consuming parts of the procedure

• Optimize queries by adding appropriate indexes, rewriting queries, or using query hints

• Break down the procedure into smaller, more manageable parts

• Use temporary tables or table variables to reduce the amount of data processed at once

• Cons...read more
Answered by AI
Add your answer
Q2. Keep SQL procedures short, use multiple small procedure with specific functionality being used, avoid use of temp tables and Joins, use select statements wisely. do not use sub queries, do not use dynamic ...read more
Ans. 
To optimize SQL procedures, keep them short, use small procedures with specific functionality, avoid temp tables and joins, use select statements wisely, avoid subqueries and dynamic SQL.
• Break down complex procedures into smaller ones with specific functionality

• Avoid using temporary tables and joins whenever possible

• Use select statements wisely to retrieve only the necessary data

• Avoid subqueries and find alternative ap...read more
Answered by AI
Add your answer

Q1. Technical questions about some
Add your answer

Q1. Personal questions about previous job and salary
Add your answer

Q1. Explain different types of HL7 messages
Add your answer
Q2. Difference between 1C 2C 3C attribute types in DICOM
Add your answer

2 coding questions ( 1 easy , 1 medium) along with some mcqs on Hackerearth.
The test was for c++.

Q1. The technical round was of 1 hour. He asked OOPS concepts and 4 coding questions.(3 easy, 1 medium)
Add your answer
Q2. Core OOPS concepts. Polymorphism and it's types Constructors , copy constructors, etc.. along with implementations. Deadlocks and how to prevent it. 1. Given n-1 positive numbers all from 1 to n, find t...read more
Add your answer

Q1. Went through the resume and asked questions related to it. Since I mentioned DSA, he asked one question related to BST. Rest were just conversation.
Add your answer

Q1. Just talked over phone about salary negotiations.
Add your answer

Interview process went two technical and one Manager round
it took one week tom complete entire process.