1- Merge in sql
2- how to define multiple request if coming to loadblancer and there are 3 app servers are there
3-Coding guidelines
4- which complex things done in project last time
5- which design pattern you have used in projects
6- what architecuture you have followed in project
7- inner jon vs left vs right outer join
8- Have you given any solution or design for any project
9- Trigger in sql afterinsert, afterupdae
10- dense_rank vs Rank in sql
11- services and middleware in .net core
12- what are the major challenges you have faced while migrating .net core 2.1 to 8
13- IServiceCollection
14- IHttpClientFactory
15- IScoppedFactory
16 - Can we call parent stored proc variable inside the child stored procedure
17-Extention method in c#
18-Singlton vs Scopped
19-AWS lamda function
20 -Explain about last good project -Falcon
21- how you were doing the communication b/w windows services and web api
22- write the entities used for centrialized notification system
23- what things as a solution archtitect you follow for developer or team to improvet the system
24 - reverse the integer no 13492 without using any inbuild method
25- how many ways we can trigger the function app
26- how timer trigger works
27 - which azure certification you have done no
28 - how to define relationship for one to many many to one , like student can have multiple course and multiple course can have multiple student
how you define entity relationship in entity framework and how to define in sql table
29 - how to call microservices in sysnchronus manner like order service is there and if shifpment is taking time then how to do that customer should not get the information about the shipment is not ready but order is canelled
30- model binding in .net core
31- directive in angualr and write the custom directive in anglar
32 - write the code for singlton pattern
33- how to implement session or enable in .net core
34- how to implement jwt token authoriztion
35- how to implment response cache in .net core
36- write code for transfer value from one component to other component
37- how to implement asynchronous programming in .net core
38 - how to cancel thread or async program
39 - write the code to implment custom exception middleware
40 - differenct b/w addscopped and addtransient
42-ngzone in angular
43-what is rest in angulat or api
44- how to implement localazation in mvc
45- what is the altenate of sticky sessions if we have used AWS ELB and if we have multiple instance to make session live if we switch the node
46- aws cdk
47- if we have multiple application and each applicaiton is having multiple api end points then how we will migrate to clude what will be the approach
48- if we have ERP applicaitation then which one you will use ELB ,ALB or NLB in which scenarios
49-what you will do if you have applicaiton have some files on S3 storage how you will transfer the file from one locatation to another locaiton and also mail to other sysyem
50- when ECS container service is spin up then it takes too much time what you will do make it faster
51- how to implement certificate like on premises for authentication and authorization in azure or aws side
52- jwt authentication how it works
53 TLS in load balanceing
54 -how routing works in angualr
55-lazy loading in angular
56-grpc api
57- first or firstordefault
58- write the program to get the no of character count form string like Indian
59-write the query to get the 9 highest postioned salary in company
60 - Rank vs denseRank
61- how to run different node version angualr version application in same system
62- Filters in MVC
63- How authguard,canactivate works in angular
64- how authguard service works in angualr
65- how components communicate each other in angular
66- how lock work in singlton pattern and how to improve the performance of if we have used lock
67- which design pattern you have used
68 - how many trigger type
69- how inserted can be used for retriving old and new values in triggers
70 - how indexs works in sql
71-how interceptor works in angualr
72- promise vs obeservable
73-what issue you have faced while upgrading angular 11 to 18
74-transient vs scopped
75-how to create custom middleware in .net core
76-difference b/w use and run in .net core
78-how to pass parameters in angualr app to call api end point if we dont know the source
79- http put vs patch
80 - http post vs put
81- attribute routing in .net core
82- ngif vs nghide in angular
83- cors
Create Trigger empTrigger on emploloyee
insert into Employeelog values (inserted.empi)
sp1
declare var1
set var1
select 'Bhupender'
select 'Bhupender' + null
emp
a 1000 1
b 1000 1
c 2000 2
d 3000 3
class Car
{
start();
run();
}
static class ExtnCar
{
static stop(this Car c )
{
}
}
builder.Services.AddSingleton<AService>();
builder.Services.AddScoped<BService>()
class AService -singleton
{
AService(BService b){}
}
class BService scopped
{
BService(AService a){}
}
int x = 0;
int y = null;
