Lti mind tree
Stack vs heap
What’s Garbage collector How does it work ?
If I don’t want to create instance of a class, how to do it without using static or abstract
How to create dependency injection ?
Where the injected dependency will be there ?
Ado. Net ?
Entity frame work - migrations commands
Can i use Stored procedure with [Link] ?
How to di erentiate between sql query & stored procedure while using [Link]
What’s Constructor chain ?
Hashtable vs dictionary
Ienumerable vs iqueriable
What is Partial class ? Whats the use ?
Types of null reference exception
Task vs multithread
If we have multiple projects under a solution,
Can we have a class in one project and it’s partial class in other project ?
Sql
Views vs indexes
Triggers
If we have employee table with id,name,salary,comision ——
Sql query to get employee data and if comision is null return 0 for that column ?
Di erence between sp & function ?
What is sp ?
Epam
TR
Find no of repeated elements in sequence in a string and return as alphabet+number format
Linq query to group & sum a list of elements
Di & life times
Async & await
Iqueriable vs innumerable & which inherits what ?
Authentication & authorization
Logging
Exception handling
Middlewares
Design parttetns, factory pattern ?
REST principles
Routing
Model validation
Http methods
Di between 200 & 201 status code
Asnotracking
What to use for clean code ?
Dry ?
Indexes in sql
Di between where & having
ff
ff
ff
ff
Ef databse rst vs code rst approach
Migrations
If a user is facing issue with a api how do you start analysis on this issue from cloud ? What’s
idisposable & where will you use
What’s Multi threading
Task vs thread
.net framework vs .net core… di in developer perspective
Ref vs out
2nd round
How do you use Azure functions and how do you extract data from request ?
How do you connect azure keyvault to .net web api ?
Di examples for all life times, speci cally asked about scoped and when you would use that
Content negotiation, how to return xml format ?
CORS
Micro services architecture
Carelon
What version of .net you are using in project
Whats the latest features of .net
Whats di between .net frane work & .net
How latest .net is better than framework in performance
How will u return a error msg to client
Ajax, jquery
Ref vs value type
How Jwt works
What if the token is expired ?
Ienumerable vs iqueriable
How to display multiple views ? Same data in Multiple pages
If u have 2 drop downs, cust & orders in mvc how will u display data e ciently
Code for letter count in string
linq query to join 2 tables
Exception handling
Finally block
What does Jwt token contain
Can we use post attribute on a get action ?
Hashset vs dictionary and their use cases
How parallel programming work
2nd round
Intro roles responsibilities
Tell about current Project
How did you resolve a complex issue, explain analysis and x that you gave
How do you identify a index is missing
Why & how do you introduce caching
Why memory caching, why not redis
Explain Solid principles
ff
fi
fi
ff
fi
fi
ffi
Gave Code snippet that violates open/closed principle and asked to identify the issue and
suggest a solution
Whats abstract class & why do we need it
Any questions for me ?
Accenture
1st round
Introduce yourself
1 Explain Oops
2 Inheritence & multiple inheritance
3 Types of polymorphism
4 How to call a method if same method is there in multile interfaces
5 project & role
6 swap two variables without 3rd variable
7 how did you do exception handling in your project
8 how do we return a response in what format we return the fetched data from db( dto)
9 view bag in mvc, MVC life cycle methods
10 let vs var js
11 how to get input from user using js
12 action vs actionview in mvc
13 action return types in mvc
14 security authentication in api
15 asynchronous programming
16 multi threading
17 what framework used in project
18 how to design sql db
19 constraints in db
20 stored procedures
21 index & cluster indexes
22 hosted the app ?
23 attributes where we declare them
24 what are microservices
25 delegates in c#
Cognizant
Roles & responsibility
Project
Design patterns
Dependency injection & lifetimes
Async await
Project tasks planning
Agile
How are you helping juniors
Experience with Estimations
Experience with Client interaction
Ienumerable vs iqueriable
How to do validations before http req hits controller
Authentication & authorisation
How to prevent sql injection
Rate limiting
Api versioning
Return Types in mvc
How will you write frontend in mvc
Routing in mvc
How will you design mvc page components
Can we use same view for di erent controllers
Exception handling in mvc
If we use scopped & sql connection had expiry time of 60 seconds how to handle that with Entity
framework
Eager loading
Stored procedures
Cte
Functions
Can functions has multiple return types ?
Types of joins
If a table has child table how to load child along with parent using entity framework
What you used with azure
Ci cd ?
Experience with Oauth ?
Deloitte
Intro
Solid principles & uses
Dependency injection
Authentication & authorisation
Asynchronous programming
Jwt mechanism
Exception handling
Singleton implementation code
Func vs action in delegates
Delegates implementation code
Anagram code
Code to nd 3rd largest number in array
Design patterns used in project
Cqrs
How to prevent sql injections
Unit testing framework ?
Why nunit is used
Mocking vs stubbing
Globaldata
Intro
Project explanation
Which module you worked on
How you will query to get db data
What orm you used ?
fi
ff
Interface & its usecase
Constructor & when it will red in api ?
[Link] ( ) vs [Link] ( )
How youll x the slow mvc page ?
Jquery ?
Linq query to get train data , crew data if crew has train id ?
Types of caching ?
Redis cache & where its data is stored ?
Dependency injection & types ?
What di type youll use for db connection?
How you will implement in memory cache & where youll con gure, where data is stored for this ?
Sql query to get depart ment with 0 employees ?
Types of joins ?
How to get 5th highest salary of employee ?
Apart from index what can we do for sql optimisation?
Whats the keyword to get last inserted record in sql ?
Stored procedures
Verisk Interview
Introduction
Project role, tech stack
Exception handling
Method overload vs ovrride
How to optimize sql query
Any challenge you faced in recent project
How to connect sql connection with application
What sql are you using in project
Sql query to select all patients group by doctor id on today date for consultation
Find 3rd largest element from a given array using only 1 loop
Multithreading
How multiple requests were being executed at same time paralelly
Write a skeleton for rest api
What is rest api
fi
fi
fi