ACERCA DE ESTE EPISODIO
👉 Integrate GitHub Copilot and ChatGPT into your daily work: https://aw.club/global/en/courses/ai-supported-software-engineering
In this episode of "Mock Interview Show #5", we dive into .NET and Angular coding interview questions and answers. Whether you're a beginner or have 4+ years of experience, this session will provide valuable insights into real-world technical interviews.
Watch as Ruchi Arora, our candidate, takes on challenging coding problems and navigates in-depth questions from our expert interviewer, Mahesh Gali. Hosted by https://www.youtube.com/@SumitRamteke, the episode wraps up with honest feedback and key takeaways to help you sharpen your skills.
Don’t miss this opportunity to see a live technical interview in action!
NAVIGATION
0:00 - Intro
3:50 - Web API
8:02 - C Sharp
13:34 - ASP.NET Core
16:33 - EF.NET
21:13 - SQL Server
26:36 - .NET Unit and Integration Testing
29:38 - Software Design
34:01 - Design patterns
36:03 - Architecture
40:44 - SDLC
43:27 - Code task C Sharp
50:00 - Code task SQL
1:01:26 - Angular
1:07:39 - Feedback session
TOPICS and PRACTICAL TASKS
.NET:
Web API:
1. Please explain REST principles.
2. What are the different http methods you used and can you explain them?
3. Explain the concept of content negotiation.
4. What is CORS?
5. Explain the error handling mechanism you implemented for your Web API.
C#:
1. Explain about generics and can you demonstrate with an example?
2. Explain about run time polymorphism and its uses.
3. Can you explain how to clear unmanaged resources?
4. Explain the methods you used in Task Parallel Library and their applications.
5. Explain about TaskCompletionSource.
ASP.NET Core
1. Please explain where we use custom middleware and how can we build one?
2. How to implement model validation?
3. What are the different options we have to store environment specific sensitive information in an asp.net core application?
EF.NET
1. Which approach did you use and can you explain more about how you implemented it?
2. Explain about entity data model.
3. What are the different entity states we have and their usage?
4. Explain Tracking vs. No q -Tracking
5. Explain how to use the Entity Framework Profiler tool to identify performance bottlenecks in Entity Framework applications.
SQL Server
1. Explain pros and cons of indexes.
2. What are some best practices for writing efficient stored procedures?
3. Explain about the execution plan and its applications.
4. Explain the different isolation levels in SQL
.NET Unit and Integration Testing
1. What is the role of unit tests in CI/CD pipeline?
2. Explain AAA principles.
Software Design:
1. Explain dependency inversion principle
2. Explain code smell with examples. How do you find all code smells in a source code?
Design patterns:
1. What are design patterns and what is the main purpose of using them?
Architecture:
1. Explain the current project architecture.
2. Monolithic vs micro services - pros and cons.
SDLC:
1. What is Definition of Ready vs Definition of Done
2. What are the different estimation techniques you used?
Angular:
1. Explain the difference between Angular's JIT and AOT compilation
2. Explain how change detection works in Angular
3. Describe the purpose and use cases of RxJS in Angular
4. You've been tasked with optimizing the performance of an existing Angular application. What steps would you take to identify and address performance issues? Provide specific examples of tools and techniques you would use.
5. Explain the different types of testing in Angular and the tools/frameworks you used
Handson:
C#:
- Print the number of occurrences of each character in a string.
SQL:
DROP TABLE IF EXISTS ROOM;
CREATE TABLE ROOM (
ROOM_ID INT PRIMARY KEY,
ROOM_NAME VARCHAR(255)
);
DROP TABLE IF EXISTS EMPLOYEE;
CREATE TABLE EMPLOYEE (
EMPLOYEE_ID INT PRIMARY KEY,
NAME VARCHAR(255),
ROOM_ID INT,
FOREIGN KEY (ROOM_ID) REFERENCES ROOM(ROOM_ID)
);
We have 2 tables: ROOM (ROOM_ID, ROOM_NAME) and EMPLOYEE (EMPLYEE_ID, NAME, ROOM_ID)
Please find a single employee who sits in the most overcrowded room.
WHERE TO WATCH US AND LISTEN
🔸 YouTube: https://youtu.be/NmWvXZmJfVc
🔸 Apple Podcasts: https://bit.ly/awclub-en-apple
🔸 Spotify: https://bit.ly/awclub-en-spotify
🔸 Download mp3: https://anywhereclub.simplecast.com/episodes/35
#engx #dotnet #angular
