ValueLabs .Net Ineterview Questions

1.Give some Scenario for Non Clustered index?

2.Can we write system defined functions in side The Function?

3.What is the Unique Data type?

4.I have a table in which phno is one of the columns.i do have some values in tht phno column.
i need to update phno column values with 0(zero) as prefix.give me a correct solution plz.

5.what is IDE,DMV in sql server?

6.Where is global assembly cache located on the system?

7.What is the difference between functional test type and navigation test type?

8.What is an assembly?

9.Give difference between Intranet application, client server application, and web based application
Are applications developed in Java, html, servletts client server or web based..

10.Is web based application a 2 tier or 3 tier application.

11.what is 2 tier and 3 tier application.

12.How can we Achieve Late binding in C#.Can any give one example.

13.Difference between regression testing and re-testing

14.how u get the build ?what is the size of the build?

15.Can we share session between ASP.Net & ASP

16.Which Security Algorithm used to encrypt the data? a) DES b)RC2 c)Triple DES d)All the above

17.Can we Classic ASP,.Net 1.0, .Net 1.x and .Net 2.0 installed on the same system?

18.what is the difference between HashMap and Hashtable

19.Difference between DataGrid and Girdview?

20.Difference b/w .Net 2.0, 3.0 and 3.5 ?

21.Diff b/w dispose & Finalize Methods?


SQL Server Interview Questions :
1.What is the difference Between Sql-server 2000 & 2005

2.What is the use of placing primary key and foreign key constrains on columns.

3.What is the difference between distinct clause and group by clause?

4.Can I remove the default constraint columns in SQL SERVER?