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
84- Repository pattern'
85-SaFe agile
86- PI planing
89- How microservices commnunicate each other
90- bindings in azure function app
91- how to improve the performance in font end ,backedn api ,db, and stored proc, EF ,linq ,cache
92-how to design the tables and normalize it
93- what is differecne b/w azure storage queue and service bus queue
94- how to trigger funciton app via queue
95 - expain execution plan in sql
96- how to monitor or identity api performance
97- use vs run in .net core
98-how to revert the transaciton if something failed due to bussiness validation or service down in microservice of orchestrator patter saga
97 - open api documentation
98- how do you implment azure authenticaiton in .net cor and angualr
99- while implementing security which 3 vulnerability is going to be occur if like certificate implmented
100- for api gate way write a function for ratelimiter which will limit the user request per min also tell about how to make it scalable in .net core
101-design a notification service and draw diagram which will send the mail,slack and web apps
102- write the method to url shortner or url long
104- what poc or suggestion u have given for project
105- how api version will work and how you will maintain or define the api versioning minor majaor version
106-how to make zero downtime when deploying to azure or any environment web app
106- how to containairized a webapp using docker and deploy to azure
107-what are the major key components considering while moving from onpremises to azure
108-cors in .net core api
109-why to choose .net core over .netframework
110-what is azure landing zone and what are the main keys for this
111-method overloading like for different return data type
112-what to do imporve performance on azure side for app service
112 what to do to improve the performance of database side storeproc table
113- how to improve the performance for entity framework
114- eagar loading and lazy loading and explicit loading in entity framework
115- what are the major things we need to consider while migrating database to azure cloud
116- example for lazy loading in entity framework
117-var vs dynamic vs object
118-clr vs cts vs cls
119- managed vs unmanaged code
120- how to improve the perforance in azure side
121- what are security related things we have to cosider for app service
122-view child vs contentchild in angualr
123-document.getready vs window.onload in javascript
124- what are the main selectors in jquery
125-executenonquery vs executequery
126- datareader role
127- differrent type of function type in sql server
128- what to do improve th performance of stored proc
129- what is role of start up file
130- what things we define in program file .net core api
131-kestral in .net core
132-ado.net vs entity framework which one is fast
133- asnotracking in entity framework
134- solid principle
135-how to pass the value from footer to header or body in angular
136- event.propogration in java script
137-dapper in c#
138- what are third part library for modal validation in web api
139- what things in web api validate the jwt token when send from front api
140- why rest api is stateless
141- how to do api testing if we have multipe apis
142- role of CDN
143- how to make higher availbility in azure or any application
143- differnt type for constructor copy construtor ,static constructor
144- static vs const vs readonly
145- how to store data using entity framework locally
146-how interceptor works in angualr and what is code
147- default access modifies
148- how to write the stored proc for datagrid paginations
149-include in entity framework
150 - fluent validation
151- dapper in c#
152 - use vs map vs run in .net core
153- egar vs explicit vs lazy loading in ef
154-in case of I use the nested uh yeah nested include keyword so any issues uh any have you ever facing any issue uh if I use the uh nested include uh nested issue uh so basically uh nested uh like uh like order payment any other so like a three or four navigation properties are used or include so have you facing any issues?
155- modal binding in .net core
156- ref vs out vs in
157-touple in c#
158- recors in c#
159- first and single in linq
160-drawback of repostiory pattern
161-how to use serilog in .net core
162-task vs theread vs async
163- replay subject vs subject
164-azure migration
165- azure applicaiton gateway
166- azure api gateway vs loadbalancer
167- what is the benefit of api gateway in microservices
168- how to secure api
169- how to secure api so that other user can not use jwt token and use th api
169- cross site scripting attack
170- azure and code vulnerability tool
171-antiforgery token
172-private endpoints in azure
173- open door in azure
174-how to two different cloud application will access
175- how to access on premises data base to azure cloud app services
176- CICD
177- AKS and docker
178- azure network securtiy group
179-azure front door
180-CQRS
181-Circuit breker polly and resillience
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;
How to find the sum of digits of a positive integer?
The user will input a positive integer and the method should return the sum of all the digits in that integer.
input: 168, output: 15 (1 + 6 + 8)
168
1
68
10
8
Animal Sound Simulator
Problem Statement:
Create a base class Animal with a method MakeSound(). Then create at least three derived classes (Dog, Cat, Cow) that override the MakeSound() method to return their respective sounds.
Then, write a method that takes a list of Animal objects and calls MakeSound() on each, demonstrating polymorphism.
Sample output:
Dog says: Woof!
Cat says: Meow!
Cow says: Moo
/**
* This task should be completed where you can filter
* accounts based on the user's input.
* 1. debounce the user input with a delay of 250ms
* 2. after the delay of 250ms execute `getAccounts()` where
* the first parameter is the input's value
* - note: `getAccounts` takes 2.5 seconds, if the user enters in a new query
* while getAccounts is being executed then you should cancel the current
* request to getAccounts and make a new one.
* 3. conditionally show the loading indicator on line 34 when getAccounts is being executed.
* 4. show the results in the div on line 37
* - set the `filtered` property to the result of `getAccounts`.
* - ex: If you type 'bob' you should display Bob.
* - ex: If you type 'o' you should display John and Bob.
* - ex: If you type 'b' you should display Bob and Jeb.
*/
@Component({
standalone: true,
selector: 'app-root',
imports: [CommonModule, FormsModule, ReactiveFormsModule],
template: `
<div style="margin-bottom: 8px">
<label style="display: block; margin-bottom: 8px">Search</label>
<!-- note - the value of this input should be the first parameter of 'getAccounts' -->
<input placeholder="enter a search string" type="text" [([ngModel])="searchText"] "(textChangedEvent)" ="textEventChanged('arg')"/>
</div>
<!-- todo - make this visible only when getAccounts is being executed -->
<div>Loading</div>
<ul>
<!-- todo - display the 'name' property for each account in 'filtered' -->
</ul>
`,
styleUrl: './app.component.css',
})
export class AppComponent {
title = 'Angular';
filtered: Account[] = [];
loading = false;
searchText:string;
async ngOnInit() {
// this is only an example of how you can call getAccounts
console.log(await getAccounts('b'));
}
ngOnChanges()
{
}
async textEventChanged(arg:any)
{
Account[] account= getAccounts(searchText).subscribe(x=>{
setTimeout(250,()=>{
})
})
}
public getAccounts(searchText:any): Obserable[Account[]]
{
await getAccounts(searchText);
}
}
