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
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);
}
}
