- What is the difference between Delete and Truncate in SQL.
- You have an SQL table and you have an XML file having same schema. How to display the data from SQL database and XML file together to the user?
- You have an SQL table ‘Employee’ having fields ‘Employee Number’ and ‘Employee Name’ and an XML file having ‘Phone Number’ and ‘Employee City’. How you will show data to a user having ‘Employee Number’, ‘Employee Name’, ‘Phone Number’ and ‘Employee City’ to the user.
- What is the difference between Clustered and Non-clustered index?
- What you use to have user defined event to fire before any of the application events? Options available are a) Global.asax b) HttpHandler c) HttpModule d) None of these.
- Write a query to select table without index. ‘Select * from table with (index=0)’
- How you will filter a dataset?
- How you will sort a dataset?
- What is done to remove dll hell?
- Which authentication is preferred for an application in internet?
- What are diffgrams?
- what is ‘yield’ in C#?
- What are nullable type?
