SQL
My procedure is getting slower, How can I make it faster?
Triggers (do they affect the performance of a table) complete details?
JOINS?
DDL vs DML?
UNION, UNION ALL, INTERSECT?
Result tables?
Temp tables: local vs global?
How to get highest salary of an employee from employee table (it could be second highest third
highest so write a generic solution)?
Sequence in sql?
How to sort a column without using its name?
How to aggregate multiple strings?
What is the difference between primary key and unique key?
What is composite key?
What is indexing (including benefits and drawbacks)?
Clustered vs non clustered index?
What is CTE?
What is the difference between where and having clause?
Group by and Prtition by?
Window functions: RANK(), DENSE_RANK(), ROW_NUM(), COUNT(),SUM(),MIN(),MAX()?
String Aggregate functions: String_Agg (), Split string(), charIndex()?
Switch case vs IF else Vs IIF?
Subqueries?
Procedure vs Function?
Input parameters vs Output parameters?
Diff b/w Join and Inner Join?
Views in sql with details?
Cascading?
Can a foreign key be null?
Data integrity vs Referential integrity?
Execution plan?
Select * from users (using this statement I want to insert and select data as well)
DOT NET
Routing with all types
OOP concepts
Async and await?
Views in MVC
Razor view in MVC
Partial View in MVC
Master View in MVC
Write a function which accepts only 1 int value if the value given to that function is 5 or 2 it
should give me result 7
How to keep track of each request and response in dot net core?
Filters in dot net (most important) name few of them and why do we use ?
Middleware (most important)?
RestAPI vs WebAPI?
How to register a service, middleware, filter in dot net core?
What is WebAPI request pipeline in dot net core?
Interface vs Abstract class
Var, Dynamic, Object, Const, readonly, public int property {get;}
Method overriding, method hiding, method overloading
Error handling methods? (Global exception handling)
Actionresult vs IActionresult