United Health Group Technical Interview for 4+ years experience in dotnet
United Health Group Technical Interview for 4+ years experience in dotnet. I am listing here the first round of my technical interview experience with United Health Group. This interview was for 4+ years experience in dotnet. this was a telephonic round.
United Health Group Technical Interview for 4+ years experience in dotnet.
I am listing here the first round of my technical interview experience with United Health Group. This interview was for 4+ years experience in dotnet. this was a telephonic round.
1.Difference between stored procedure and function.
Ans:A StoredProcedure can return zero or more values whereas function must return a value.
Stored Procedures can have both input and output parameters whereas functions can have only input parameters.
Stored Procedure allows select and Insert,Update,Delete statements in it whereas function can have only select statement in it.
Functions can be called from Stored Procedure whereas procedures cannot be called from a function.
WCF and Web Services
1.Difference between WCF and Web Services.
Ans:Webservices can only use HTTP/HTTPS protocol. We cannot use TCP/MSMQ protocols with it.
WCF can use HTTP/TCP/MSMQ/Named Pipes.
Web service has to be hosted in IIS whereas WCF service can be self hosted or hosted in IIS/WAS/windows Service.
WCF uses DataContract Serialization whereas WebService uses XML serialization
2.How do we know that which address the client is connecting to in case of a WCF Service.
Ans:using endpoints which has address where the WCF service is located.
1.Difference between Structures and Classes.
Ans:Classes are Reference types and Structures are Values types.
Classes will support an Inheritance whereas Structures won't.
We cannot have instance Field initializers in structs but classes can have instance Field initializers.
classes can have constructors but structs do not have default constructors
2.Does Structure implement Inheritance/Interface?
Ans:There is no inheritance concept for structs but a struct can implement interfaces.
3.Can Structures have constructors. How the members of the structures are initialized.
Ans:No Structures do not have default constructors. whereas paramterized constructors are allowed.
4.Difference between Value Types and Referenec Types.
Ans:A variable that is declared pf value type(int,double...), stores the data, while a variable of a reference type stores a reference to the data.
Value type is stored on stack whereas a reference type is stored on heap.
Value type has it own copy of data whereas reference type stores a reference to the data.
5.When an integer variable is declared in a class. Is this integer variable a value type or a reference type.
Ans: It is a value type but the memory is allocated on heap.
5.Difference between ref keyword and out keyword.
Ans:ref keyword tells the compiler that the object is initialized before it enters the function, whereas the out keyword tells the compiler that the object will be initialized inside the function.
6.Is there any difference when you pass a value type using a ref keyword and a reference type using a ref keyword.
Ans:No Difference because when you pass any value type or a reference type to a method by reference using the 'ref' keyword, it will pass the reference to the actual data. There is no copying of the value.
7.Difference between readonly and const keywords. can you use these keywords with reference types.
Ans:The value of const is set at compile time and can't change at runtime
Const are static by default.
The readonly keyword marks the field as unchangeable. However it can be changed inside the constructor of the class
8.What are delegates and events. What is the default handler in C#.
9.What is polymorphism. What are the types of polymorphism and how they are implemented.
10.Difference between exe and dll.
11.Types of assemblies
12.Is public static void Main() method available in console based applications/Windows/Web applications?
13.A dll in GAC and a dll on a network which one is secure and why?
1. Difference between MVVM pattern and n-tier architecture.
2.Advantages of using MVVM pattern
3.Have you used PRISM in your project.
Thanks for posting such a nice question with the answer for 4+ years experience.
Now a days there are the requirements in UHG and i hope most of the folks are preparing for attending the interviews. Such kind of initiatives will definitely take them to crack the interviews.
Thanks a lot. For the remaining questions which are unanswered i will try to post the answers.