Sql server / ADO.NET interview questions

[viking]

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?

[nswan]

print out a stored procedure and ask him what it's doing. That's 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

[Nerseus]

Hopefully any SQL Server questions will be around SQL and not around managing SQL Server itself (unless you're 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 don't expect anyone to answer every question, but we ask to just to see what level everyone is.

 

ADO.NET, I'd think you'd be asked what some of the basic objects are (DataSet, DataTable, DataView, DataReader, etc.), how much you've 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

[rufus]

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.

[viking]

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?