Interview Question

C#  question 

1. Explain the difference between a class and an object.
2. Explain the difference between "readonly" and "const" keywords in C#.
3. Describe the difference between "abstract class" and "interface" in C#.
4. Explain the purpose of the "base" keyword in C#.
5. Explain the purpose of the "async" and "await" keywords in C#.
6. What is a static class in C# ?
7. Explain what is meant by "boxing" and "unboxing" in C#.
8. Access modifiers in C#
9. Difference between for and forEach.
10. Explain what is meant by serialization in C#.
11. What is the difference between Abstraction and Encapsulation ?
12. What is collection? 
13. Difference between IEnumerable and IQueryable ? 

Practical question

• You are working on health care application. Please describe various model class you would take and How you can achieve inheritance in this also
• Can you have a private class ?
• Yes but only in case of nested class
• What is Break and continue keyworks in c# and Can we use break keyword in forEach

==========================================================4

ASP.Net

1. difference between ASP.NET Core and ASP.net
2. Explain the concept of middleware in ASP.NET Core
3. What is dependency injection (DI) and how is it used in ASP.NET Core?
4. What is appsetting.json file in Asp.net core?
5. How routing works ?
6. What is an ORM and which ORM you prefer ?
7. What is Model Validation. Describe different ways to validate a Model.
8. Explain HTTP verb.
9. What is JWT ?

Practical question

•    How reastFull api work ? it is stateless but if we need to identify the user state how we can achieve that ?
• Describe the mechanism of JWT authorization.

==========================================================4

Angular

1. What is NgModule in Angular?
2. What is data binding in Angular and explain its types.
3. What are directives in Angular?
4. Describe the purpose of services in Angular.
5. What are pipes in Angular and how are they used?
6. What is routing in Angular?
7. What is lazy loading in Angular and how is it implemented?
8. Explain the concept of observables and subscriptions in Angular.
9. Describe the concept of lifecycle hooks in Angular.
10. How to communicate between parent and childs
11. What is Package.json file
12. State management

==========================================================4

SQL server

1. Explain the difference between clustered and non-clustered indexes in SQL Server.
2. What is a stored procedure in SQL Server
3. Describe the difference between a scalar function and a table-valued function in SQL Server.
4. Describe the difference between DELETE and TRUNCATE commands in SQL Server
5. What is the purpose of the HAVING clause in SQL Server?
6. Describe the purpose of the CASE statement in SQL Server.
7. What are windows function? 
8. What is CTE and explain using a example. 
9. What is the purpose of normalization ?

Practical 

1. How to call a procedure 
2. Write a query to retrieve second-highest salary from employee table. 
3. You have two tables user table and address table and you have to make a relation between tthese two table. What will be your approach ? 
4. Please design a basic schema for hospital application 

==========================================================4

Entity Framwork

1. What is Entity Framework (EF)
2. Different approaches in EF

==========================================================4

JavaSript

1. Describe the difference between undefined and null in JavaScript.
2. What is the purpose of the this keyword in JavaScript?
3. Describe the difference between == and === operators in JavaScript.
4. What are truthy and falsy values in JavaScript?
5. Explain the concept of hoisting in JavaScript.
6. Describe the difference between let, const, and var in JavaScript.
7. What is a callback function in JavaScript?
8. Explain the purpose of the Promise object in JavaScript.
9. What are arrow function ? 
10. How to declare a function ?