.
NET Full Stack Interview Cheat Sheet
SECTION: .NET CORE & WEB API
- 1. Difference between .NET Core and .NET Framework
.NET Core: Cross-platform, open-source, modular.
.NET Framework: Windows-only, mature, full-featured.
- 2. Dependency Injection in .NET Core
Use IServiceCollection to inject services in Program.cs.
- 3. Securing API with JWT
Use AddAuthentication().AddJwtBearer() with token validation parameters.
- 4. API Versioning
Use [ApiVersion("1.0")] and versioned routes.
- 5. Global Error Handling
Use custom middleware or app.UseExceptionHandler().
SECTION: SQL SERVER
- 6. DELETE vs TRUNCATE vs DROP
DELETE: Logged, rollback supported. TRUNCATE: Fast, no rollback. DROP: Deletes table.
- 7. Index Types
Clustered: Sorts actual data. Non-clustered: Separate index with pointer.
- 8. What is a CTE?
A temporary result set for readable recursive queries.
- 9. Optimizing Queries
Use indexes, avoid SELECT *, check execution plans.
- 10. Transactions
Use BEGIN TRAN, COMMIT, and ROLLBACK for ACID compliance.
SECTION: ANGULAR 10
- 11. New Features
Stricter typing, DateRangePicker, faster builds.
- 12. Two-Way Binding
Implemented using [(ngModel)].
- 13. Subject vs BehaviorSubject
Subject: No initial value. BehaviorSubject: Holds latest value.
- 14. Lifecycle Hooks
ngOnInit, ngOnDestroy, etc. to manage component lifecycle.
- 15. Interceptors
Used to add headers or handle errors in HTTP requests.
SECTION: AZURE (PaaS / SaaS / Integration)
- 16. IaaS vs PaaS vs SaaS
IaaS: VMs. PaaS: App Services. SaaS: O365.
- 17. Azure App Service
Managed hosting for APIs and web apps.
- 18. Azure Key Vault
Secure secret storage with managed identity access.
- 19. Azure Service Bus
Decoupled message queue system.
- 20. API Management (APIM)
Gateway for securing and monitoring APIs.