.net intrvw q & A

Diff between CLR and MSIL in .net
what is FCL and use of it in .net
Diff between sql Functions vs Stored procedures
Define cursors ,Views with example queries in sql
What is satelite assembly in .net use of it
what  is the diff between count and count big in sql
what is sql profiler
what is indexed view in sql
Diff between datareader vs dataset in ado.net
Diff between execute reader vs execute scalar vs execute non query  in ado.net
 what is dead lock in sql
what is sql concurrency how to handle in sq l
what is lock,unlock,Rowlock,Nolock in sql
what  are the sql  transactional isolation levels ,define its use
Diff between input and out parameters in sql queries
How to improve performance in asp.net page
in .net  what is cache ?
Diff between partial vs out put cache
Diff between user control vs Custom control .How to implement ur page
what is com component
what is dom in xml
what is  xml attributes
in javascript how to check all check boxes vs  single checkbox
in sql How to get  3-rd maximum salary  in a table
in sql how to get 90-th max salary
in sql how to get last fieldvalues of table
what is ajax ? what is the use of  it
Diff between javascript vs Ajax
Explain Ajax content template ,Ajax triggers
what is the diff between stored procedure vs cursor vs views vs triggers vs functions in sql .why we use seperate
in which situation r u use left join ,left outer join ,full outer join,inner join
what is set row count  in sql
what is sql identity insert
what is diff between scope identity vs @@identity