Wednesday, December 28, 2016

Capgemini Dotnet Interview Questions

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?
8.       What are collection classes in C#? Name few of the collection classes?
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
               

1 comment :

  1. SQL Query for 4th Question


    Declare @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)

    ReplyDelete