HCL Interview Questions For 3 + Years of Experience in MS.Net

In this article i would like to share HCL Interview Questions For 3 + Years of Experience in MS.Net.Which i face recently in hyderabad location.



1.What is the Differences between Control State and View State?

2.What is the Difference between DataAdapter and DataReader?

3.How to find the 5th Highest maximum salary using Linq?

4.How to remove the duplicate characters in a given string?
E.G:Naga Veerendra
o/p:Nag Verndr

5.Can you explore the concept of Reflection?

6.What are the different namespaces used for Refelection?How did you know the properties of a class using Reflection?

7.I have 1 lakh records in a table then i need to show 1000 records in a Grid per every page.How can you handle this without using a performance hit?

8.What is COLESCE in SQL?

9.Consider the following two tables
Patient

PatientID	PatientName

 BloodPressure

ID	BP	CreatedDate

Here every patient bloodpressure is changes for every 1 hour

1.It requires PatientID,PatientName,BP for all patients whose BP is of Latest entered

2.Don't repeat the patients.

Note:Each patient is having more than 1 BP because every 1 hour BP of the patient changes

10.What is SQL Tunning?

11.Consider the following tables i.e Employee,Department

EmpID	EmpName	DeptID	Sal

ID	DName	Location

Write a query to find the total department salary information with DeptID,Dname,Location and TotalSalary using sqlstatements 

Implement the same with LINQ.

12.Explain the All types of Bindings in WCF?

Hope these Questions useful.All the Best!!!!!!