HP. net job interview questions

HP. net job interview questions

 

1) What's the difference between left join and inner join?
2) What's the difference between char, varchar, nvarchar? When
Will nvarchar use? Why nvarchar can't replace use varchar?
3) how to handle simultaneous access and visit the database
For read, delete, insert event in the same time?
4) What's the datetimesatmp data type in the SQL server?
5) What's the keyword different with the out, ref?
6) What's the following key words mean in C #: Param, lock?
7) What's the key word 'using' could do in C #?
8) What's DTD in the XML?
9) Why don't use cursor often? How to Relize the recordset
Modification row by row without cursor in a stored proccedure?

10) What are the key word need to escape in XML?
11) What's your page dividing arithmetic in the database
Stored Procedure?