Developer Interview
By master_mas •
hey all,
so,
I have this interview on sunday..
for a Developer position..
..
I am asking if any one there knows what kinda of questions should i be expecting..?!
And what r the best answers should i give so that i can impress the interviewers..?!
..
plz help..
thanks..
What is normalization? Explain different levels of normalization?
What is denormalization and when would you go for it?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What's the difference between a primary key and a unique key?
What are user defined datatypes and when you should go for them?
What is bit datatype and what's the information that can be stored inside a bit column?
What is a transaction and what are ACID properties?
Explain different isolation levels
What are constraints? Explain different types of constraints.
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are the steps you will take, if you are tasked with securing an SQL Server?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
check in job sites... they usually give nice tips on this one...
more importantly, be prepared to give confident answers.
Before you go for the interview, be prepared to explain the database design of one of your latest projects. Don't be surprised if the interviewer asks you to draw ER diagrams.
Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt!