Public Health Engineering Department Executive Engineer Interview Questions, Process, and Tips

Q1. How do you find the code performance issue in the code deployed in production?
Ans. 
To find code performance issues in production, use monitoring tools and profiling techniques.
• Use monitoring tools like New Relic, AppDynamics, or Datadog to track performance metrics and identify bottlenecks.

• Use profiling techniques like CPU profiling, memory profiling, and network profiling to pinpoint specific areas of the code that are causing performance issues.

• Analyze logs and error messages to identify patterns a...read more
Answered by AI
View 1 more answer
Q2. What is asynchronous programming
Ans. 
Asynchronous programming is a programming paradigm that allows multiple tasks to run concurrently without blocking each other.
• Asynchronous programming is used to improve the performance of applications that require a lot of I/O operations.

• It involves the use of callbacks, promises, and async/await keywords in JavaScript.

• Asynchronous programming can be used in both front-end and back-end development.

• Examples of asynchro...read more
Answered by AI
Add your answer
Q3. Write a program to change background after every 0.5 sec interval to orange,white,green on button click in Angular?
Ans. 
Program to change background color on button click in Angular
• Create a button in Angular template

• Add click event listener to the button

• Use setInterval() function to change background color after every 0.5 sec

• Use ngStyle directive to change background color dynamically
Answered by AI
Add your answer
Q4. How to load a component only after 3 of my services are loaded?
Ans. 
Use Angular's 'resolve' property to load component after services are loaded.
• Create a resolver service that waits for all three services to complete before resolving.

• Add the resolver service to the 'resolve' property of the component's route.

• Access the resolved data in the component using the ActivatedRoute service.

• Example: { path: 'my-component', component: MyComponent, resolve: { data: MyResolverService } }
Answered by AI
Add your answer
Q5. What is difference between iquerable and ienumrable
Ans. 
IQueryable is for querying data from a source that implements IQueryable interface while IEnumerable is for iterating over a collection of data.
• IQueryable is used for deferred execution while IEnumerable is used for immediate execution.

• IQueryable is used for querying data from a remote data source while IEnumerable is used for querying data from an in-memory collection.

• IQueryable is more efficient for large datasets as...read more
Answered by AI
Add your answer
Q6. When you go with entity framework and ado.net
Ans. 
Entity Framework is an ORM while ADO.NET is a data access technology.
• Entity Framework is easier to use and provides more abstraction than ADO.NET.

• ADO.NET is faster and more flexible than Entity Framework.

• Use Entity Framework for simple CRUD operations and ADO.NET for complex queries and performance-critical applications.
Answered by AI
Add your answer

It was straightforward

Q1. Was easy explaining about role
Add your answer
Q2. Previous experience. How to handle the role and expectation. Work schedule. Explain about the team
Ans. 
The candidate should discuss their previous experience, how they handle their role and expectations, their work schedule, and provide an explanation about their previous team.
• Discuss previous experience in software engineering roles

• Explain how you handled your role and met expectations in previous positions

• Describe your typical work schedule and any flexibility you have

• Provide an overview of your previous team, their s
Answered by AI
Add your answer

String and arrays duplicate and sorting questions

Q1. Project details
Add your answer
Q2. Project deployment
Add your answer

Q1. Previous company details
Add your answer
Q2. CTC discussion and company review
Add your answer

50 questions 12 mins

Q1. Quant based questions (P&C,Averages,probability) followed by case study
Add your answer

It was a 45 mins online aptitude test

We had 2 rounds in Group discussion

Q1. The interviewer asked to solve the question live in a video call
Add your answer

Q1. The interviewer asked to explain by final year project
Add your answer

Q1. A very genric aptitude test.
Add your answer

Q1. Interview with a senior person and was based on data analysis / data interpretation. Case study -ish discussion.
Add your answer

Q1. Generic HR round
Add your answer