Sql server / ADO.NET interview questions

V

viking

Member
Joined
Jul 2, 2003
Messages
7
Can someone please tell me what SQL Server 2000 questions could be asked to a guy who is primarily a VB.NET front end programmer. Also what questions could be asked to him on ADO.NET?
 
print out a stored procedure and ask him what its doing. Thats what i got asked in my interview.

You could also ask him what situations to use a datareader in, when to use a dataset etc... for ado.net
 
Hopefully any SQL Server questions will be around SQL and not around managing SQL Server itself (unless youre applying to be a DBA). Things like "what is an outer/inner join" or "what is normalization, have you ever used it, why would you want to" are reasonable. Our interviews are VERY robust and we dont expect anyone to answer every question, but we ask to just to see what level everyone is.

ADO.NET, Id think youd be asked what some of the basic objects are (DataSet, DataTable, DataView, DataReader, etc.), how much youve used them, have you run into any quirks, have you used Expression columns, have you used binding, how have you updated the database (custom SQL, DataAdapter, Command object, etc.).

-Nerseus
 
In general they will be questions bascially on the SQL Server management, what kind of different services it provides. what the replication methods used. They will give you a situation where you have to choose which type of SQL sever edition you have to use. (there are 7).

About ADO.NET, they will give some senario and ask you to use the appropriate methods like sort,filter, row state enumeration and all.
 
I have a collegue who asks one question to all those guys "What are the different collection classes in .NET" Quite frankly I dont know the answer to that too..but I dont wanna ask.

Does anyone know what the hell that means?
 
Back
Top