Philips Innovation Campus Senior Software Engineer Interview Questions and Answers

Basics of C++. Solve some problem by given complexity. Find the bugs in code.

Q1. Question from your last project.
Add your answer
Q2. Design pattern in C++.
Ans. 
Design patterns in C++ are reusable solutions to common problems in software design.
• Design patterns help in creating flexible, maintainable, and scalable code.

• Examples of design patterns in C++ include Singleton, Factory, Observer, and Strategy.

• Each design pattern has a specific purpose and can be applied in different scenarios.
Answered by AI
Add your answer

Q1. What is the use of button when link can submit the form?
Ans. 
Buttons are used when an action needs to be performed, while links are used for navigation.
• Buttons are more suitable for actions like submitting a form, saving data, or triggering a function.

• Links are used to navigate to different pages or sections within a website.

• Buttons provide visual feedback when clicked, while links do not.

• Buttons can be styled and customized more easily than links.

• Buttons can have different stat
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. Tech Basic Quesions and Related to stack mostly on .net Sql and Angular
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. You are perfect fit and you are hires
Add your answer

Q1. About previous projects
Add your answer
Q2. Basic technical questions
Add your answer

Q1. Screen shared and asked me to write some code and asked to improvise the same there..
Add your answer

Q1. Coding questions mostly , followed by AWS
Add your answer

Q1. Mangers were technically sound and so in general discussions, they are assessing the candidates
Add your answer