Capgemini Asp.net MVC Interview Questions
Hi Friends,
One
of my friend attended Dotnet
Interview at Capgemini, Mumbai Location. Below are the Questions, Hope these questions may helpful for the people who are searching
for a Job.
Interview is conducted for 4-6 years of
experience on Asp.net MVC, C# and sql server.
First round Technical Questions.
1.
What are the Design patterns
used in your project? What is the advantage of using Dependency Injection?
2.
Tell about your project
architecture? How do you call Entities?
3.
For Ex : I have two classes,
customer and CustomerAddress , How do
you Initialize lazy loading ?
4.
Consider a class "Customer" having below fields CustomerID, CustomerName, Age, Gender, email,
and mobileno Write a query lambda
expression to filter customer details (CustomerID, CustomerName, email and
Mobile No ,exclude Gender and age) having age greater than 20.
5.
Difference between var and
dynamic key word?
6.
What are Delegates in C# ?
Explain with a Scenario where we can use Delegates?
7.
How to create custom event
Handlers?
9.
Difference between collection
classes and Generic collection classes? What are the advantages of Generic
collections?
10.
What are Action filters in MVC?
11.
How Routing works In MVC?
12.
Different ways to handle
exceptions ? How do you Implemented Exception handling in your
project ?
13.
Can you tell any three
differences between EntityFrame work and Dapper
classes?
Sql Server :
1.
What is the use of CTE ?
2.
When to use @table variable and
temp table?
3.
What steps do you consider while Optimizing Query ?
4.
Interviewer provided laptop and
asked to write a Query from below table
Retrieve count of
different statuses, month wise
RequestSubject
|
RequestDetails
|
Status
|
CreatedDate
|
PaymentFailed
|
PaymentFailed
|
New
|
14-10-2016
|
Transaction
Error
|
Transaction
is failed due to techinical error
|
WIP
|
14-10-2016
|
InSufficent
Funds
|
Transaction
is failed due to InSufficient funds
|
Completed
|
17-10-2016
|
OrderNotRecevied
|
Still
awaiting for the Order
|
WIP
|
20-10-2016
|
PaymentFailed
|
Transaction
Declined due to Insufficient funds
|
Completed
|
21-10-2016
|
Transaction
Error
|
Unable to
place an order
|
New
|
02-11-2016
|
Fund transfer
|
Failed to
transfer funds
|
WIP
|
03-11-2016
|
PaymentFailed
|
Transaction
failed due to technical issues
|
New
|
11-11-2016
|
Order
Cancelled
|
Order
cancelled in valid communication address
|
Completed
|
15-11-2016
|
Expected Output:
Status
|
Count
|
Month
|
NEW
|
1
|
Oct-16
|
WIP
|
2
|
Oct-16
|
Completed
|
2
|
Oct-16
|
NEW
|
2
|
Nov-16
|
WIP
|
1
|
Nov-16
|
Completed
|
1
|
Nov-16
|
SQL Query for 4th Question
ReplyDeleteDeclare @tab_count table (
RequestSubject varchar(200),
RequestDetails varchar(200),
Status varchar(200),
CreatedDate datetime
)
Insert into @tab_count values ( 'PaymentFailed', 'PaymentFailed', 'New', '10-14-2016')
Insert into @tab_count values ( 'Transaction Error', 'Transaction is failed due to techinical error', 'WIP', '10-14-2016')
Insert into @tab_count values ( 'InSufficent Funds', 'Transaction is failed due to InSufficient funds', 'Completed', '10-17-2016')
Insert into @tab_count values ( 'OrderNotRecevied', 'Still awaiting for the Order', 'WIP', '10-20-2016')
Insert into @tab_count values ( 'PaymentFailed', 'Transaction Declined due to Insufficient funds', 'Completed', '10-21-2016')
Insert into @tab_count values ( 'Transaction Error', 'Unable to place an order ', 'New', '11-14-2016')
Insert into @tab_count values ( 'Fund transfer', 'Failed to transfer funds', 'WIP', '11-13-2016')
Insert into @tab_count values ( 'PaymentFailed', 'Transaction failed due to technical issues', 'New', '11-13-2016')
Insert into @tab_count values ( 'Order Cancelled', 'Order cancelled in valid communication address', 'Completed', '11-15-2016')
Select distinct [status],count([status]), convert(varchar(7), CreatedDate,121) as CreatedDate from @tab_count
group by [status],convert(varchar(7), CreatedDate,121)