Comprehensive Interview Question Bank: .NET, SQL, Angular, Web API, and System Design

-

General & Conceptual

  1. What is dependency injection?

  2. Difference between middleware and filters?

  3. What is rate limiting?

  4. What is REST architecture?

  5. Difference between functions and subquery?

  6. Return types of Web API action methods?

  7. Why do we use caching?

  8. How to manage states in Web API?

  9. How do you design a secure API?

  10. Windows function in SQL?

  11. Performance optimization techniques in SQL?

  12. Custom middleware?

  13. About tracing and tracing methods?

  14. What is stateful and stateless authentication?

  15. Advantages of using webhooks in Web API?

  16. To avoid cursors, what else can we use if we need to check row by row?

  17. Advantages and disadvantages of synchronous operation?

  18. Query for selecting latest names records from user table in LINQ?

  19. Why does SELECT come at last?

  20. How to pass value from controller to view?

  21. How to rectify error?

  22. Some LINQ questions?

  23. What is 2NF?

  24. Authentication and authorization?

  25. Introduction?

  26. What is DROP and TRUNCATE?

  27. What are HTTP status codes?

  28. How to do pagination in Web API?

  29. Async/await vs async result?

  30. Tracing in .NET?

  31. What is INTERSECT clause?

  32. How to manage/handle state?

  33. How to do SQL query optimization?

  34. How to do caching?

  35. What is CORS?

  36. Middleware vs action filters?

  37. Controller action return types?

  38. What is composite key?

  39. Pros of EF Core?

  40. SQL scenario questions?

  41. How to handle deadlock?

  42. How do you optimize database query?

  43. Suppose there is high traffic, how do you handle scaling?

  44. How to secure Web API?

  45. How do you handle SSO in application?

  46. Suppose API gets 1000 requests at a time, how do you handle them?

  47. How do you encrypt your data before sending it to the API?

Coding & LINQ

  1. Write a LINQ query to segregate filenames into publication/section/page groups.

  2. Write a LINQ query for 4 highest salary (also same with SQL Server).

  3. Reverse a string in code?

  4. Replace a value in a string or variable?

Databases & SQL

  1. What databases have you used in your projects?

  2. What is SQL transaction?

  3. When to go for stored procedure vs function in SQL?

  4. Types of joins?

  5. Difference between UNION and UNION ALL?

  6. Can we have the same index name in two different tables?

  7. Can we use ROLLBACK after a DELETE operation?

  8. How do we implement an approval method on the SQL/database side?

  9. Explain window functions in SQL.

  10. Difference between ROW_NUMBER, RANK, DENSE_RANK?

  11. Difference between LEAD and LAG?

  12. Write a query to find duplicate records.

  13. Write a query to drop duplicate records using window function.

  14. What are CTEs? Explain with scenario and syntax.

  15. CTEs vs subquery for performance optimization?

  16. What is temp table and syntax?

  17. CTEs vs temp table for query performance?

  18. What is stored procedure?

  19. What are views in SQL and how to use them?

  20. How to execute an SSIS package?

  21. What are different methods of executing packages?

  22. Explain EOD function in SQL.

  23. Which function is used to get last 1 month data from today?

  24. Display 4th highest salary?

  25. How to find duplicate values from particular row in SQL?

Power BI / Data Engineering

  1. Difference between append and merge in Power Query?

  2. Challenges faced in Power Query?

  3. What is query folding in Power Query?

  4. What is incremental refresh in Power BI?

  5. In Direct Query, how to deal with large datasets (SQL views vs CTEs)?

  6. Explain star schema and snowflake schema.

  7. Explain fact tables and dimension tables with scenario.

  8. Explain ETL in SSIS.

  9. What are packages in SSIS?

  10. Difference between ALL and ALLEXCEPT in DAX?

  11. Explain SAMEPERIODLASTYEAR example in DAX.

  12. Difference between RELATED and LOOKUPVALUE in DAX?

  13. What are deployment pipelines in Power BI service?

  14. How to transfer dashboards from Dev → UAT → Prod?

  15. What is incremental load?

  16. How do you identify new vs old data?

  17. What fields help for incremental logic?

  18. How do you build a pipeline to fetch data from SQL Server in ADF?

  19. What is row-level security in Power BI?

  20. What is semantic layer?

  21. Explain data mart.

  22. How to create apps in Power BI?

  23. How to transfer dashboards in app?

  24. How to provide access to end number of users in app?

  25. How to grant access for 20 reports in Power BI?

  26. What is Synapse data and Azure Data Pipelines?

  27. Explain slow changing dimension and its types.

Web / API / .NET Core

  1. What is startup class?

  2. Difference between app.Run and app.Use?

  3. Examples of middleware?

  4. Where to store static CC email ID for easy change?

  5. How to host website in IIS?

  6. Website + API in IIS: how many application pools required?

  7. Disadvantages of pooling both website and API in single pool?

  8. How to automate daily file download from website?

  9. What libraries to use to communicate exe with code?

  10. How to implement secure API?

  11. How to read data from appsettings.json?

  12. Explain session and state management techniques in .NET Core?

  13. How to send email from button click with dynamic subject/body?

  14. For AJAX call, what properties do we use?

  15. What parameter do we use for endpoint in AJAX?

  16. How to handle exception logging?

  17. How did you handle API versioning?

  18. How do you handle rate limit in API?

Angular / Frontend

  1. What is Angular?

  2. What is change detection in Angular?

  3. What are Observables and Promises? Key differences?

  4. What is Dependency Injection in Angular?

  5. What is NgRx?

  6. What is RxJS?

  7. What is SPA (Single Page Application)?

  8. How do you optimize Angular app performance?

  9. What is role-based authentication?

  10. Different approaches to authentication without third-party libraries?

  11. AG-Grid in Angular?

  12. Importance of middleware?

  13. What is signal in Angular?

  14. DataTable controls in Angular?

  15. Security features used in Angular + .NET app?

  16. Difference between jQuery and JS?

  17. How login credentials are encrypted?

  18. How user claim is checked?

  19. How you handle lazy loading?

  20. Did you use real-time notification mechanism?

  21. What is decorator?

  22. How to pass data from child to parent component?

  23. Micro-architecture in Angular?

  24. What is interceptor?

  25. Eager loading vs lazy loading?

  26. Create custom pipe?

  27. How OOP is implemented in your project?

  28. Difference between struct and class?

  29. Async/await difference?

  30. Difference between abstract class and interface?

  31. Difference between var and dynamic?

  32. IEnumerable vs IQueryable?

  33. Most usable RxJS operators?

  34. Promise vs Observable?

  35. Difference between Angular 10 and 13?

  36. How to resolve circular dependency problem?

MVC / Web Development

  1. What are action filters in MVC?

  2. What is REST API?

  3. Routing in MVC?

  4. What is middleware in .NET Core?

  5. Caching in .NET Core?

  6. What is startup class in .NET Core?

  7. Difference between click and on event in jQuery?

  8. Difference between Web API and REST API?

  9. Difference between .NET Core and .NET?

  10. Difference between document.ready and window.load?

  11. How to optimize webpage load performance?

  12. What are design patterns?

  13. What is process of deployment and which IIS version used?

  14. Difference between dynamic and static?

  15. What is serialization?

  16. What is application pool?

  17. What are filters in MVC?

  18. What are SOLID principles?

  19. Query to update gender column (male ↔ female)?

  20. What are session management objects?

  21. What is CLR?

  22. What is MVC?

Miscellaneous

  1. Tell me about yourself.

  2. Previous client project explanation.

  3. Explain your current project/module/role.

  4. Explain previous projects.


This was part of Interview Preparation With Bipin — Let’s Crack It!

Comments

Post a Comment

Popular posts from this blog

Angular Architecture

-
Image
Angular Architecture is divided into different parts like Component, Template, Directive, Service, and Module. Before you start to develop your application, you should have knowledge about the purpose of each part of the application. So that you can make your application smoother and faster. Below is the figure of angular architecture. Angular Architecture In this chapter, we will see each term in detail. Module Angular Applications are modular and Angular has its own modularity system called NgModule. Every Angular application has at least one class with a @NgModule decorator, it is the root module, conventionally named as AppModule. To use any component into an application you need to declare it into the related module. Angular Module is class with a @NgModule decorator. Code Snippet of Angular Module The most important properties of @NgModule are : declarations:  declaration property contains ...
Read more

Why should I learn Angular?

-
It is one of the most growing and advanced technology for create a Single Page Applications(SPA). Here the things why you should learn Angular. It is one of the Google Technology Easy to Learn, if you’re familiar with Java Script and UI Nowadays Single Page Applications(SPA) is the trend. If you want to increase your career opportunities Having a lot of Fun while working with Angular If you’re familiar with OOPS then Angular 4 is easy to code Typescript which helps you to create OOPS based Front End Design Lot of resources available to learn Angular And lot more…
Read more

Solid Principle

-
SOLID Principle What are the SOLID principles? Five object-oriented design principles  help make code: Maintainable (easy to change without breaking things) Extensible (easy to add new features) Testable (easy to write unit tests) Understandable (easy for other developers to read) The five principles: S – Single Responsibility Principle (SRP) One class = one reason to change. O – Open/Closed Principle (OCP) Open for extension, closed for modification. L – Liskov Substitution Principle (LSP) Subclasses should work wherever base classes work (no broken contracts). I – Interface Segregation Principle (ISP) Clients should not be forced to depend on methods they don’t use. D – Dependency Inversion Principle (DIP) Depend on abstractions, not concrete classes. Why are we using SOLID principles? Reduce bugs when requirements change → You can modify code without breaking unrelated parts. Improve maintainability → Code is easier to und...
Read more