SQL Server Interview Questions And Answers

This is post going to be more like a list of question for self assessment. So I will not be providing answer, instead of that I will provide the link for the best answer I can find on internet. I am pretty much sure you know most of the answers. I will be adding new questions frequently.

Q. what are the Codd's rule for RDBMS ?

https://en.wikipedia.org/wiki/Codd%27s_12_rules

Q. Describe index in Sql Server?

https://msdn.microsoft.com/en-us/library/ms190457.aspx

Q. Explain ACID properties of database transaction?

https://en.wikipedia.org/wiki/ACID

Q. What is Tempdb and how it is useful in Sql Server ?

https://msdn.microsoft.com/en-us/library/ms190768.aspx?f=255&MSPPError=-2147217396

Q. What is MSDB ?

https://msdn.microsoft.com/en-in/library/ms187112.aspx

Q. What is Master Database?

https://msdn.microsoft.com/en-us/library/ms187837.aspx

Q. What is Model Database?

https://msdn.microsoft.com/en-us/library/ms186388.aspx

Q. What is Resource Database?

https://msdn.microsoft.com/en-us/library/ms190940.aspx

Q. Explain Transaction Isolation level in Sql Server ?

https://msdn.microsoft.com/en-us/library/ms190940.aspx

Q. what is Statistics in Sql Server?

https://msdn.microsoft.com/en-us/library/ms190397.aspx?f=255&MSPPError=-2147217396

Q. What is Views in Sql Server and how many types are there?

https://msdn.microsoft.com/en-IN/library/ms187956.aspx

Q. What is execution plan in Sql Server?

https://technet.microsoft.com/en-us/library/ms178071%28v=sql.105%29.aspx?

f=255&MSPPError=-2147217396

Q. What is Subquery and describe types of it?

 https://technet.microsoft.com/en-in/library/ms189575%28v=sql.105%29.aspx?

f=255&MSPPError=-2147217396

https://technet.microsoft.com/en-in/library/ms175838(v=sql.105).aspx

Q. What is cursor in Sql Server?

https://technet.microsoft.com/en-us/library/ms191179(v=sql.105).aspx

Q. Explain transactions in Sql Server?

https://technet.microsoft.com/en-us/library/ms190612(v=sql.105).aspx

 Q. What is distributed queries?

https://technet.microsoft.com/en-us/library/ms188721(v=sql.105).aspx

Q. What do you mean by Lock and Latches in Sql Server?

https://technet.microsoft.com/en-us/library/ms189849(v=sql.105).aspx

https://msdn.microsoft.com/en-us/library/ms177421.aspx

Q. What is a Job in Sql Server and how to schedule it?

https://msdn.microsoft.com/en-IN/library/ms190268.aspx?f=255&MSPPError=-2147217396

https://msdn.microsoft.com/en-in/library/ms191439.aspx

Q. What do you know about Dynamic Management Views and Functions in Sql Server ?https://msdn.microsoft.com/en-us/library/ms188754.aspx

Q. What is Trigger in Sql Server?                                                                                  https://msdn.microsoft.com/en-IN/library/ms189799.aspx 

Recommended book for Interview 

SQL Server Interview Questions

SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators